| From: | Scott Ribe <scott_ribe(at)killerbytes(dot)com> |
|---|---|
| To: | Alvaro Herrera <alvherre(at)commandprompt(dot)com>, Postgres general mailing list <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Autovacuum Improvements |
| Date: | 2006-12-21 17:41:24 |
| Message-ID: | C1B01554.5E041%scott_ribe@killerbytes.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
> I intend to work on the maintenance window idea for 8.3. I'm not sure
> if I'll be able to introduce the worker process stuff in there as well.
> I actually haven't done much design on the stuff so I can't say.
Something to consider, per-day maintenance windows, where Sat & Sun could
have 24-hour window, and trying to vacuum largest tables during longest
windows. This wouldn't work for every server, but for many...
--
Scott Ribe
scott_ribe(at)killerbytes(dot)com
http://www.killerbytes.com/
(303) 722-0567 voice
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2006-12-21 17:41:32 | Re: Autovacuum Improvements |
| Previous Message | Teodor Sigaev | 2006-12-21 17:39:29 | Re: TSearch2 Changeset 25387 |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2006-12-21 17:41:32 | Re: Autovacuum Improvements |
| Previous Message | org | 2006-12-21 17:36:02 | SPAR Simple PostgreSQL AddOn Replication System |