Re: Cube Index Size - Mailing list pgsql-hackers

From Alexander Korotkov
Subject Re: Cube Index Size
Date
Msg-id BANLkTikhjw88W93dNUGU7Yi_r-Hh=e9OOw@mail.gmail.com
Whole thread Raw
In response to Re: Cube Index Size  (Teodor Sigaev <teodor@sigaev.ru>)
Responses Re: Cube Index Size
List pgsql-hackers
2011/6/1 Teodor Sigaev <teodor@sigaev.ru>
One of idea is add sorting of Datums to be splitted by cost of insertion. It's implemented in intarray/tsearch GiST indexes.

Yes, it's a good compromise between linear and quadratic entries distribution algorithms. In quadratic algorithm each time entry with maximal difference of inserion cost is inserted. Quadratic algorithm runs slowly than sorting one, but on my tests it shows slightly better results.
 
 ------
With best regards,
Alexander Korotkov. 

pgsql-hackers by date:

Previous
From: "Greg Sabino Mullane"
Date:
Subject: Re: pg_listener in 9.0
Next
From: Dave Page
Date:
Subject: Re: pg_listener in 9.0