| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dann Corbit | 2004-03-29 22:24:55 | Re: Contrib question |
| Previous Message | Stephan Szabo | 2004-03-29 22:19:25 | Re: Interval constant syntax, was Re: Interval & check |