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 Greg Williamson
Subject Re: A 154 GB table swelled to 527 GB on the Slony slave. How to compact it?
Date
Msg-id 1331855059.93188.YahooMailNeo@web46110.mail.sp1.yahoo.com
Whole thread Raw
In response to Re: A 154 GB table swelled to 527 GB on the Slony slave. How to compact it?  (Filip Rembiałkowski <plk.zuber@gmail.com>)
Responses Re: A 154 GB table swelled to 527 GB on the Slony slave. How to compact it?
List pgsql-general
Tree view 
Filip Rembiałkowski suggested:


>> On Thu, Mar 15, 2012 at 6:43 AM, Aleksey Tsalolikhin <atsaloli.tech@gmail.com> wrote:
>>
>>
>> Is there any way to consolidate the pages on the slave without taking
>> replication offline?
>>
>>
>maybe CLUSTER?
>
<...>
>
>Of course events destined to this table will be queued by Slony while the table is locked.
>

I've not much recent experience with Slony, but possibly pg_reorg, found at:

  <http://pgfoundry.org/projects/reorg/>

would be of use ...

Greg Williamson

pgsql-general by date:

Previous
From: Doug Gorley
Date:
Subject: Zero-length character breaking query?
Next
From: BrunoSteven
Date:
Subject: Problem for restoure data base Postgre