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