Postgres Pro
Downloads
Home   >   mailing lists

Re: Execute VACUUM FULL when DB touches a specific size ? - Mailing list pgsql-admin

From Scott Marlowe
Subject Re: Execute VACUUM FULL when DB touches a specific size ?
Date
Msg-id j2idcc563d11004042024w10c18f0etb2738c62290a663b@mail.gmail.com
Whole thread Raw
In response to Execute VACUUM FULL when DB touches a specific size ?  (Nilesh Govindarajan <lists@itech7.com>)
Responses Re: Execute VACUUM FULL when DB touches a specific size ?  (Nilesh Govindarajan <lists@itech7.com>)
List pgsql-admin
Tree view 
On Sun, Apr 4, 2010 at 8:21 PM, Nilesh Govindarajan <lists@itech7.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.

pgsql-admin by date:

Previous
From: Nilesh Govindarajan
Date:
Subject: Execute VACUUM FULL when DB touches a specific size ?
Next
From: Nilesh Govindarajan
Date:
Subject: Re: Execute VACUUM FULL when DB touches a specific size ?