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 Scott Marlowe
Subject Re: A 154 GB table swelled to 527 GB on the Slony slave. How to compact it?
Date
Msg-id CAOR=d=2jj0vA6v5zRCjwH0A2EpPrycM3iVjEgFrvmVtyR=WcQw@mail.gmail.com
Whole thread Raw
In response to Re: A 154 GB table swelled to 527 GB on the Slony slave. How to compact it?  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-general
Tree view 
On Wed, Mar 14, 2012 at 10:57 PM, Scott Marlowe <scott.marlowe@gmail.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.

pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: A 154 GB table swelled to 527 GB on the Slony slave. How to compact it?
Next
From: "krzf83@gmail.com "
Date:
Subject: Re: permission denied to create extension "ltree" Must be superuser to create this extension.