Re: [HACKERS] Tsearch2 index size

2006-10-23 Thread richard-pgodbc
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. Th

[HACKERS] Tsearch2 index size

2006-10-23 Thread richard-pgodbc
I am running versions 8.1.2 and I installed 8.2B last week. I dumped the data from the old version into the new version. The db consists of several million records. Total disk usage is approximately 114GB. My two observations are as follows... Also, keep in mind these are truly just observat