From: | ITAGAKI Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org, pgsql-patches(at)postgresql(dot)org |
Subject: | Adjust autovacuum naptime automatically |
Date: | 2006-08-17 01:45:00 |
Message-ID: | 20060817103831.5F44.ITAGAKI.TAKAHIRO@oss.ntt.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
Hi hackers,
There is a comment in autovacuum.c:
| XXX todo: implement sleep scale factor that existed in contrib code.
and the attached is a patch to implement it.
In contrib code, sleep scale factor was used to adjust naptime only to
lengthen the naptime. But I changed the behavior to be able to shorten it.
In the case of a heavily update workload, the default naptime (60 seconds)
is too long to keep the number of dead tuples low. With my patch, the naptime
will be adjusted around 3 seconds at the case of pgbench (scale=10, 80 tps)
with default other autovacuum parameters.
I have something that I want to discuss with you:
- Can we use the process-exitcode to make autovacuum daemon to communicate
with postmaster? I used it to notify there are any vacuum jobs or not.
- I removed autovacuum_naptime guc variable, because it is adjusted
automatically now. Is it appropriate?
Comments welcome.
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
Attachment | Content-Type | Size |
---|---|---|
autovacuum_adjust_naptime-0817.patch | application/octet-stream | 9.2 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Dunstan | 2006-08-17 02:14:20 | Re: Enum proposal / design |
Previous Message | Gregory Stark | 2006-08-16 23:21:06 | Re: Enum proposal / design |
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2006-08-17 02:33:50 | Re: Adjust autovacuum naptime automatically |
Previous Message | Greg Stark | 2006-08-16 22:13:23 | Re: CREATE INDEX ... ONLINE |