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: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
Is there any functionality contained in vacuum that is not contained in
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-2017 The PostgreSQL Global Development Group