Re: Tsearch2 index size

Поиск
Список
Период
Сортировка
От Jeff Davis
Тема Re: Tsearch2 index size
Дата
Msg-id 1162492272.31124.234.camel@dogma.v10.wvs
обсуждение исходный текст
Ответ на Tsearch2 index size  (richard@armchair.mb.ca)
Список pgsql-hackers
On Mon, 2006-10-23 at 13:36 -0500, richard@armchair.mb.ca wrote:
> 2. I have a tsearch2 index which is 756MB in size in 8.1.2 but balloons to 
> 910MB in 8.2!  These numbers were taken right after a REINDEX.  Normally, I 
> wouldn't care about physical index size, but this particular index is 
> sitting on a ramdisk, so size really does matter.  I see that the tsearch2 
> type was diddled with in 8.2.  Is this an intentional change to improve the 
> tsearch2 performance?

This might be due to the new FILLFACTOR feature in 8.2. This parameter
defaults to 90. If you set it to 100, then you should get similar
results as in 8.1.

I don't know much about the new GIN indexing, but from what I've read I
would expect the index to actually be smaller. 

Regards,Jeff Davis



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

Предыдущее
От: "Henry B. Hotz"
Дата:
Сообщение: Re: Design Considerations for New Authentication Methods
Следующее
От:
Дата:
Сообщение: Coding style question