From: Gaetano Mendola <mendola@bigfoot.com>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Cc: Michael Adler <adler@pobox.com>
Subject: Re: vacuum slowed by syslogd
Date: Thu, 15 Jan 2004 03:46:09 +0100
Message-ID: <4005FEF1.4040509@bigfoot.com> (raw)
In-Reply-To: <20040114031030.GA18188@pobox.com>
References: <20040114031030.GA18188@pobox.com>
Michael Adler wrote:
> On many occasions, I've noticed that some PostgreSQL activity takes far longer than it previously did and that disabling syslogd addresses the symptoms.
>
> Most recently, it took 20-60 seconds to VACUUM a small, heavily updated table, while it used to take a fraction of a second. I found syslog entries like these:
>
> 13:19:53 --Relation sometable--
> 13:20:03 Removed 2 tuples in 1 pages.
> 13:20:23 ^ICPU 0.00s/0.00u sec elapsed 0.00 sec.
> 13:20:54 Pages 1: Changed 1, Empty 0; Tup 4: Vac 2, Keep 0, UnUsed 13.
> 13:20:54 ^ITotal CPU 0.00s/0.00u sec elapsed 60.12 sec.
>
> It took almost-exactly 60 seconds, but virtually no CPU time was used (and no disk IO). Many similar examples have "real" times that are near perfect multiples of 10 seconds (e.g. 50.09, 40.07). This is not every single VACUUM, but it is frequent.
>
> The problem disappears when syslogd is stopped or when PostgreSQL disables syslog usage. This is very consistent and I can reproduce the problem in some installations by toggling these factors on and off.
>
Did you try to put a "-" before the file log name ?
Example:
LOCAL0.* -/var/log/postgresql.log
Regards
Gaetano Mendola
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: mendola@bigfoot.com, adler@pobox.com
Subject: Re: vacuum slowed by syslogd
In-Reply-To: <4005FEF1.4040509@bigfoot.com>
References: <20040114031030.GA18188@pobox.com> <4005FEF1.4040509@bigfoot.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox