From: | "Steve Brett" <steve(dot)brett(at)e-mis(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: When do I Vacuum ? |
Date: | 2001-12-10 10:32:21 |
Message-ID: | 9v250d$1ggs$1@news.tht.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)tincan(dot)org> wrote in message
news:Pine(dot)LNX(dot)4(dot)10(dot)10112070948530(dot)29916-100000(at)tincan(dot)org(dot)(dot)(dot)
> 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(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2001-12-10 10:34:21 | Re: How to make a REALLY FAST db server? |
Previous Message | Bruce Momjian | 2001-12-10 10:15:45 | Re: alternative place to download pgaccess |