Skip site navigation (1) Skip section navigation (2)

Contrib question

From: "Dann Corbit" <DCorbit(at)connx(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Contrib question
Date: 2004-03-29 22:23:44
Message-ID: D90A5A6C612A39408103E6ECDD77B829408D4D@voyager.corporate.connx.com (view raw or flat)
Thread:
Lists: pgsql-general
Is there any functionality contained in vacuum that is not contained in
pg_autovacuum?
 
Suggestion:
Modify the base schema for tables and add a timestamp column for the
last vacuum operation, and a timestamp for the last vacuum analyze.
Finally, a timestamp for the last time that the data was modified via
insert update or delete would be handy (but I realize that this
timestamp might be problematic).
 
With that data, a crude autovacuum could be generated periodically
whether or not statistics were enabled.
 

pgsql-general by date

Next:From: Dann CorbitDate: 2004-03-29 22:24:55
Subject: Re: Contrib question
Previous:From: Stephan SzaboDate: 2004-03-29 22:19:25
Subject: Re: Interval constant syntax, was Re: Interval & check

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group