Re: Tsearch2 index size - Mailing list pgsql-hackers

From richard-pgodbc@armchair.mb.ca
Subject Re: Tsearch2 index size
Date
Msg-id cone.1161636516.938094.11114.1000@oldbob
Whole thread Raw
In response to Tsearch2 index size  (richard-pgodbc@armchair.mb.ca)
List pgsql-hackers
> 
>> 2. I have a tsearch2 index which is 756MB in size in 8.1.2 but balloons to 
>> 910MB in 8.2!
> 
> FILLFACTOR?
> 

Tom, 

Of course!  I had it in my head that fillfactor had to be explicitely set.  
But then, after RTFM, it looks like there are defaults!  Thank you!

One more inane question, though.  The default fillfactors are currently 
#define'ed.  Is there or will there be a way to set the default fillfactor, 
using a system table perhaps?  I realize this is just a convenience, not 
integral to fillfactor functionality...

I sniffed around the docs and mailing lists but I could not find an answer.  My apologies if this question has been
answeredalready.
 

Richard Whidden


pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: COPY does not work with regproc and aclitem
Next
From: Tom Lane
Date:
Subject: Re: COPY does not work with regproc and aclitem