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

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Aleksey Tsalolikhin <atsaloli(dot)tech(at)gmail(dot)com>
Cc: pgsql-general <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-15 04:59:16
Message-ID: CAOR=d=2jj0vA6v5zRCjwH0A2EpPrycM3iVjEgFrvmVtyR=WcQw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Mar 14, 2012 at 10:57 PM, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> wrote:
> If the du -s numbers don't change or only a little then feel free to
> either run a single update while running
>
> watch "df -h /var/lib/where/my/data/dir/lives"
>
> and being ready to hit CTRL-C if you see if running your machine out of memory.

OR batch them in batches of x 10000 or so and df or du in between.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Aleksey Tsalolikhin 2012-03-15 05:43:49 Re: A 154 GB table swelled to 527 GB on the Slony slave. How to compact it?
Previous Message Scott Marlowe 2012-03-15 04:57:55 Re: A 154 GB table swelled to 527 GB on the Slony slave. How to compact it?