Re: vacuum slowed by syslogd - Mailing list pgsql-admin

From Michael Adler
Subject Re: vacuum slowed by syslogd
Date
Msg-id 20040114214618.GA26619@pobox.com
Whole thread Raw
In response to Re: vacuum slowed by syslogd  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
On Tue, Jan 13, 2004 at 11:36:19PM -0500, Tom Lane wrote:
> Michael Adler <adler@pobox.com> writes:
> > On many occasions, I've noticed that some PostgreSQL activity takes
> > far longer than it previously did and that disabling syslogd addresses
> > the symptoms.
> > ...
> > This evidence normally indicates a name resolution issue, but I'm not
> > sure how to test for that beyond using "hostname -v -i".
>
> I looked in Red Hat's bugzilla for similar issues, and found a mention
> that syslogd tries to reverse-lookup the address it gets each message
> from.  A delay there could act as you describe.  At least in recent RH
> releases, you can start syslogd with the "-x" switch to disable this
> lookup --- does that exist in Debian, and if so does it help?

There is no such option within Debian or the syslogd from freshmeat. Sounds nice, though.

I was able to track down a name resolution issue. The "nameserver" in /etc/resolv.conf pointed to a nonexistent host.
Thisadded ten second delays to telnetd logins and netstat -a. This seemed to be the heart of the problem, but I'm
gettingsome mixed info from the "field" and I'm still following up.  

Thanks,
Mike


pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Missing Schema
Next
From: Gaetano Mendola
Date:
Subject: Re: vacuum slowed by syslogd