Re: How to ENABLE SQL capturing???

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Jonathan Ellis wrote:
> 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.

I am not sure what to elaborate on :). Syslog is slow, logging to file
isn't. Although both will certainly slow down your installation quite a
bit, syslog will slow it down more.

If I recall correctly, it is because syslog is blocking.

Joshua D. Drake

>
> -Jonathan
>

- --

=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240
PostgreSQL solutions since 1997 http://www.commandprompt.com/
UNIQUE NOT NULL
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFGwHv6ATb/zqfZUUQRAgMlAKCcZpj+CCP50Deo/CsSCN21IyjrCACghXfN
uJQ+qsu4FI4Kjf8fpNiWgnw=
=BJ8E
-----END PGP SIGNATURE-----