Re: When do I Vacuum ?

many thanks,

it's been vacuumed daily for a week or so now and actually seems a bit more
responsive.

Steve
""Roderick A. Anderson"" <raanders@tincan.org> wrote in message
news:Pine.LNX.4.10.10112070948530.29916-100000@tincan.org...
> On Fri, 7 Dec 2001, Jan Wieck wrote:
>
> >     The question how often to vacuum depends on the database use.
> >     As  a  rule  of  thumb  I'd suggest start with vacuuming when
> >     approx. 10-30% of the data has been touched (UPDATED/DELETED)
>
> Which brings up an interesting thought.  Is there any way to query the
> databae and find out how much data has been 'CHANGED' since the last
> vacuum?  I don't remember seeing any mention of this for a year or
> longer in either GENERAL or HACKERS.
>    If there is or could be, a low usage database could be probed and
> then vacumm run if needed.  Not sure if the CPU cycles to run the cron
> job and query are lower than the 'just do it' on a set schedule would
> be.
>
>
> Cheers,
> Rod
> --
>                       Let Accuracy Triumph Over Victory
>
>                                                        Zetetic Institute
>                                                         "David's Sling"
>                                                          Marc Stiegler
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly