| From: | "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net> |
|---|---|
| To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
| Cc: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Alvaro Herrera <alvherre(at)surnet(dot)cl>, Patches <pgsql-patches(at)postgresql(dot)org> |
| Subject: | Re: Autovacuum integration patch |
| Date: | 2005-07-05 19:52:51 |
| Message-ID: | 42CAE513.3070100@zeut.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-patches |
While we are at it (assuming the autovacuum patch gets included in 8.1)
we have a few autovacuum related todo items.
These are the ones I can think of right now:
* XID Wraparound improvement, moving to per-table vacuuming rather than
per database. (8.2)
* Alter table commands to set per table autovacuum threshold settings. (8.2)
* Incorporate FSM data to improve vacuum decision making (8.2)
* Deal with stats reset better, possibly force stats reset to false if
autovacuum is enabled. (8.2)
* Add the concept of a maintenance window to autovacuum. (maybe 8.1?)
* Have the VACUUM and ANALYZE commands update the pg_autovacuum table
itself. This will allow autovacuum to work in harmony with manually
issued VACUUM's. (I would like to see this done for 8.1, but I will
understand if people demand that it wait for 8.2)
* Add some regression tests? Not sure what would be appropriate here. (8.1)
* Improve autovacuum threshold defaults (8.1)
Anyone have anything to add to the list?
Matthew
Bruce Momjian wrote:
>TODO item?
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2005-07-05 20:09:19 | Re: [PATCHES] HEAD doesn't cope with libraries in non-default |
| Previous Message | Tom Lane | 2005-07-05 19:51:32 | Re: Dependencies on shared objects |