Re: SAN performance mystery - Mailing list pgsql-performance

From Markus Schaber
Subject Re: SAN performance mystery
Date
Msg-id 449BD853.7050908@logix-tt.com
Whole thread Raw
In response to Re: SAN performance mystery  (Markus Schaber <schabi@logix-tt.com>)
List pgsql-performance
Hi, Tim,

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?

Thanks,
Markus


--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf.     | Software Development GIS

Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org

pgsql-performance by date:

Previous
From: Markus Schaber
Date:
Subject: Re: SAN performance mystery
Next
From: Markus Schaber
Date:
Subject: Re: Help tuning autovacuum - seeing lots of relationbloat