From: | "Dann Corbit" <DCorbit(at)connx(dot)com> |
---|---|
To: | "Dann Corbit" <DCorbit(at)connx(dot)com>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Contrib question |
Date: | 2004-03-29 22:24:55 |
Message-ID: | D90A5A6C612A39408103E6ECDD77B8299CA972@voyager.corporate.connx.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Of course I meant that is contained in "vacuumlo" --> stupid spell
checker auto-corrected it.
-----Original Message-----
From: Dann Corbit
Sent: Monday, March 29, 2004 2:24 PM
To: pgsql-general(at)postgresql(dot)org
Subject: Contrib question
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.
From | Date | Subject | |
---|---|---|---|
Next Message | CSN | 2004-03-29 22:35:17 | Re: PG vs MySQL |
Previous Message | Dann Corbit | 2004-03-29 22:23:44 | Contrib question |