Seems I sent my message to fast, cut in middle of a sencence:
Markus Schaber wrote:
>> A pg_dump/pg_restore cycle reduced the total
>> database size from 81G to 36G.
> If you still have the original database around,
... can you check wether VACUUM FULL and REINDEX achieve the same effect?
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Development GIS
Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org
In response to
pgsql-performance by date
|Next:||From: Markus Schaber||Date: 2006-06-23 12:32:29|
|Subject: Re: Help tuning autovacuum - seeing lots of relationbloat|
|Previous:||From: Markus Schaber||Date: 2006-06-23 11:56:16|
|Subject: Re: SAN performance mystery|