Re: How to ENABLE SQL capturing??? - Mailing list pgsql-performance

From Jonathan Ellis
Subject Re: How to ENABLE SQL capturing???
Date
Msg-id e06563880708130804i5f9277f1pe62e85c6c1e69df@mail.gmail.com
Whole thread Raw
In response to Re: How to ENABLE SQL capturing???  ("Joshua D. Drake" <jd@commandprompt.com>)
Responses Re: How to ENABLE SQL capturing???  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-performance
On 8/10/07, Joshua D. Drake <jd@commandprompt.com> wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> smiley2211 wrote:
> > Jeff,
> >
> > You are CORRECT...my queries were going to /var/log/messages...had to get
> > the Linux Admin to grant me READ access to the file...
>
> You may want to actually get that to stop. Syslog is a notorious
> performance bottleneck for postgresql.

Can you elaborate?  The only reference to this I could find was a
thread from 2004 where someone wasn't rotating his logs.

-Jonathan

pgsql-performance by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: select count(*) performance
Next
From: "Relyea, Mike"
Date:
Subject: Re: Help optimize view