| From: | "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net> |
|---|---|
| To: | pg(at)fastcrypt(dot)com |
| Cc: | "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>, "Fabien COELHO" <coelho(at)cri(dot)ensmp(dot)fr>, "Bruce Momjian" <pgman(at)candle(dot)pha(dot)pa(dot)us>, "PostgreSQL-development" <pgsql-hackers(at)postgresql(dot)org>, "PostgreSQL advocacy" <pgsql-advocacy(at)postgresql(dot)org> |
| Subject: | Re: [HACKERS] What can we learn from MySQL? |
| Date: | 2004-04-23 15:52:14 |
| Message-ID: | 33854.192.154.91.225.1082735534.squirrel@192.154.91.225 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-advocacy pgsql-hackers pgsql-www |
> Does the current implementation of pg_autovacuum have a way of setting
> windows where it is allowed to vacuum? Many large 24/7 will only allow
> vacuumming at certain times of the day.
No the current implementation doesn't, but such a feature is in the works
(planned anyway). What I was envisioning is the ability to set two
different sets of thresholds (peak / off peak). If you demand zero
vacuuming during peak times, you could set that threshold to -1, or some
such setting.
FYI I wouldn't remcommend defaulting pg_autovacuum to on until it does
this, and a few more things that are also planned (see the archives).
Matthew
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Matthew T. O'Connor | 2004-04-23 15:55:53 | Re: [HACKERS] What can we learn from MySQL? |
| Previous Message | Robert Treat | 2004-04-23 15:45:28 | Re: [HACKERS] What can we learn from MySQL? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Matthew T. O'Connor | 2004-04-23 15:55:53 | Re: [HACKERS] What can we learn from MySQL? |
| Previous Message | Robert Treat | 2004-04-23 15:45:28 | Re: [HACKERS] What can we learn from MySQL? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Matthew T. O'Connor | 2004-04-23 15:55:53 | Re: [HACKERS] What can we learn from MySQL? |
| Previous Message | Robert Treat | 2004-04-23 15:45:28 | Re: [HACKERS] What can we learn from MySQL? |