Re: When do I Vacuum ? - Mailing list pgsql-general

From Andrew Gould
Subject Re: When do I Vacuum ?
Date
Msg-id 20011207182555.68986.qmail@web13409.mail.yahoo.com
Whole thread Raw
In response to Re: When do I Vacuum ?  ("Roderick A. Anderson" <raanders@tincan.org>)
Responses Re: When do I Vacuum ?
List 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@tincan.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@postgresql.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

pgsql-general by date:

Previous
From: Jan Wieck
Date:
Subject: Re: Trigger problem
Next
From: Joe Conway
Date:
Subject: Re: Using Cursor in PostgreSQL 7.2