Skip site navigation (1) Skip section navigation (2)

Re: SAN performance mystery

From: Markus Schaber <schabi(at)logix-tt(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Cc: Tim Allen <tim(at)proximity(dot)com(dot)au>
Subject: Re: SAN performance mystery
Date: 2006-06-23 12:02:27
Message-ID: 449BD853.7050908@logix-tt.com (view raw or flat)
Thread:
Lists: 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

In response to

pgsql-performance by date

Next:From: Markus SchaberDate: 2006-06-23 12:32:29
Subject: Re: Help tuning autovacuum - seeing lots of relationbloat
Previous:From: Markus SchaberDate: 2006-06-23 11:56:16
Subject: Re: SAN performance mystery

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group