Re: How to ENABLE SQL capturing???

From: "Jonathan Ellis" <jonathan(at)utahpython(dot)org>
To: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
Cc: smiley2211 <smiley2211(at)yahoo(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: How to ENABLE SQL capturing???
Date: 2007-08-13 15:04:07
Message-ID: e06563880708130804i5f9277f1pe62e85c6c1e69df@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On 8/10/07, Joshua D. Drake <jd(at)commandprompt(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Relyea, Mike 2007-08-13 15:35:44 Re: Help optimize view
Previous Message Kevin Grittner 2007-08-13 14:07:03 Re: select count(*) performance