Re: [GENERAL] Creation of tsearch2 index is very slow

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [GENERAL] Creation of tsearch2 index is very slow
Дата
Msg-id 6532.1137801157@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [GENERAL] Creation of tsearch2 index is very slow  ("Steinar H. Gunderson" <sgunderson@bigfoot.com>)
Ответы Re: [GENERAL] Creation of tsearch2 index is very slow  ("Steinar H. Gunderson" <sgunderson@bigfoot.com>)
Список pgsql-performance
"Steinar H. Gunderson" <sgunderson@bigfoot.com> writes:
> For the record: Could we do with a less-than-optimal split here?

Yeah, I was wondering the same.  The code is basically choosing two
"seed" values to drive the index-page split.  Intuitively it seems that
"pretty far apart" would be nearly as good as "absolute furthest apart"
for this purpose.

The cost of a less-than-optimal split would be paid on all subsequent
index accesses, though, so it's not clear how far we can afford to go in
this direction.

It's also worth considering that the entire approach is a heuristic,
really --- getting the furthest-apart pair of seeds doesn't guarantee
an optimal split as far as I can see.  Maybe there's some totally
different way to do it.

            regards, tom lane

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

Предыдущее
От: "Steinar H. Gunderson"
Дата:
Сообщение: Re: [GENERAL] Creation of tsearch2 index is very slow
Следующее
От: "Steinar H. Gunderson"
Дата:
Сообщение: Re: [GENERAL] Creation of tsearch2 index is very slow