Re: Tsearch2 index size

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Tsearch2 index size
Дата
Msg-id 27663.1161632032@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Tsearch2 index size  (richard-pgodbc@armchair.mb.ca)
Список pgsql-hackers
richard-pgodbc@armchair.mb.ca writes:
> 1. The release notes indicate "more efficient vacuuming."  However, both 
> vacuums seems to take about the same amount of time, ie. approx: 9 hours.  

I think the improvements were only in btree index vacuuming, which it
sounds like isn't your big problem.

> 2. I have a tsearch2 index which is 756MB in size in 8.1.2 but balloons to 
> 910MB in 8.2!

FILLFACTOR?
        regards, tom lane


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: New CRC algorithm: Slicing by 8
Следующее
От: Jeremy Drake
Дата:
Сообщение: Re: New CRC algorithm: Slicing by 8