Re: Cube Index Size

Поиск
Список
Период
Сортировка
От Nick Raj
Тема Re: Cube Index Size
Дата
Msg-id BANLkTi=m3G2ttjP7PCRs88iuOpJ9WiUKdQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Cube Index Size  (Alexander Korotkov <aekorotkov@gmail.com>)
Ответы Re: Cube Index Size  (Teodor Sigaev <teodor@sigaev.ru>)
Список pgsql-hackers


2011/6/1 Alexander Korotkov <aekorotkov@gmail.com>
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.
 

Can we figure out some information about index i.e. whet is the height of index tree, how many values are placed in one leaf node and one non leaf level node?

Regards,
Nick

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Noah Misch
Дата:
Сообщение: Re: pg_terminate_backend and pg_cancel_backend by not administrator user
Следующее
От: Pavel Stehule
Дата:
Сообщение: is there any reason why don't create context info for RAISE EXCEPTION?