Postgres Pro
Downloads
Home   >   mailing lists

Re: A 154 GB table swelled to 527 GB on the Slony slave. How to compact it? - Mailing list pgsql-general

From John R Pierce
Subject Re: A 154 GB table swelled to 527 GB on the Slony slave. How to compact it?
Date
Msg-id 4F5E6DB2.3070800@hogranch.com
Whole thread Raw
In response to Re: A 154 GB table swelled to 527 GB on the Slony slave. How to compact it?  ("Nur Hidayat" <hidayat365@gmail.com>)
List pgsql-general
Tree view 
On 03/12/12 2:28 PM, Nur Hidayat wrote:
> If I didn't change the data type to charcater varying vaccuming the database doesn't reduce the database size

changing the data type required every tuple to get rewritten.     a
vacuum full, or a cluster likely would have done the same or better
reduction in size..



--
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast

pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: GROUP BY or alternative means to group
Next
From: Jim Ostler
Date:
Subject: Matching on keyword or phrases within a field that is delimited with an "or" operator "|"