Re: Logging SQL queries? - Mailing list pgsql-general

From Ralph Graulich
Subject Re: Logging SQL queries?
Date
Msg-id Pine.LNX.4.21.0207181412170.1483-100000@shauny.shauny.de
Whole thread Raw
In response to Re: Logging SQL queries?  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-general
Hi,

[...]
> Has anyone else come across this or is it just me?

It's not only you. I wanted to know, why syslogd ate 70% of my CPU time
and saw that it just logs enormous amounts of data to /var/log/postgres.
So the first thing was to put a hyphen in front of the logfile's name in
/etc/syslogd.conf and the second best thing was to set the debug level of
postgres to a more sane value.

After doing this and restarting both syslogd and postgres, the performance
was five to six times better than before. So, maybe we can have a note
about that in the postgres manual?


Kind regards
... Ralph ...



pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Query Performance...
Next
From: "Johnson, Shaunn"
Date:
Subject: Re: pg_restore: archiver error