Re: Execute VACUUM FULL when DB touches a specific size ?

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Nilesh Govindarajan <lists(at)itech7(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Execute VACUUM FULL when DB touches a specific size ?
Date: 2010-04-05 03:24:50
Message-ID: j2idcc563d11004042024w10c18f0etb2738c62290a663b@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Sun, Apr 4, 2010 at 8:21 PM, Nilesh Govindarajan <lists(at)itech7(dot)com> wrote:
> Hi,
>
> I wish to execute VACUUM FULL when DB touches a specific size. How to do it
> ?
>
> I'm aware about the caveats of VACUUM FULL.
>

Write a bash script that cds to the data dir and runs du -s, grabs the
value, and if it's over a certain size then run vacuum full.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Nilesh Govindarajan 2010-04-05 04:08:45 Re: Execute VACUUM FULL when DB touches a specific size ?
Previous Message Nilesh Govindarajan 2010-04-05 02:21:40 Execute VACUUM FULL when DB touches a specific size ?