Adjust autovacuum naptime automatically

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

Responses

Browse pgsql-hackers by date

  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

Browse pgsql-patches by date

  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