From: | Andrew Gould <andrewgould(at)yahoo(dot)com> |
---|---|
To: | "Roderick A(dot) Anderson" <raanders(at)tincan(dot)org>, Jan Wieck <janwieck(at)yahoo(dot)com> |
Cc: | Carsten Gerhardt <carsten(dot)gerhardt(at)ppi(dot)de>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: When do I Vacuum ? |
Date: | 2001-12-07 18:25:55 |
Message-ID: | 20011207182555.68986.qmail@web13409.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
One way of tracking changes would be a last_change
date field which would be updated every time a row was
updated. Of course, if the database is big enough
that your worried about resource utilization by
vacuum, then you might not like the additional space
consumption of a purely administrative field.
Best of luck,
Andrew Gould
--- "Roderick A. Anderson" <raanders(at)tincan(dot)org>
wrote:
> 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
__________________________________________________
Do You Yahoo!?
Send your FREE holiday greetings online!
http://greetings.yahoo.com
From | Date | Subject | |
---|---|---|---|
Next Message | Joe Conway | 2001-12-07 18:45:23 | Re: Using Cursor in PostgreSQL 7.2 |
Previous Message | Dado Feigenblatt | 2001-12-07 18:16:45 | Re: Where is PL/Python? |