Re: A 154 GB table swelled to 527 GB on the Slony slave. How to compact it?

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: A 154 GB table swelled to 527 GB on the Slony slave. How to compact it?
Date: 2012-03-12 21:42:10
Message-ID: 4F5E6DB2.3070800@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jim Ostler 2012-03-12 22:57:29 Matching on keyword or phrases within a field that is delimited with an "or" operator "|"
Previous Message Scott Marlowe 2012-03-12 21:40:30 Re: GROUP BY or alternative means to group