From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
---|---|
To: | Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | autovacuum launcher eating too much CPU |
Date: | 2007-09-13 16:16:52 |
Message-ID: | 20070913161652.GA1716@alvh.no-ip.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi,
Darcy Buskermolen noticed that when one has many databases, the autovac
launcher starts eating too much CPU.
I tried it here with 200 databases and indeed it does seem to eat its
share. Even with the default naptime, which I wouldn't have thought
that was too high (it does make the launcher wake up about three times a
second though).
I'm looking at a profile and I can't seem to make much sense out of it.
It seems to me like the problem is not autovac itself, but rather the
pgstat code that reads the stat file from disk. Of course, autovac does
need to read the file fairly regularly.
Here is the top lines of gprof output.
Comments? Is there something here that needs fixing?
--
Alvaro Herrera http://www.advogato.org/person/alvherre
"Investigación es lo que hago cuando no sé lo que estoy haciendo"
(Wernher von Braun)
Attachment | Content-Type | Size |
---|---|---|
profile.out | text/plain | 8.3 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2007-09-13 16:30:21 | Re: Postgresql.conf cleanup |
Previous Message | Bruce Momjian | 2007-09-13 16:13:27 | Re: Patch queue triage |