Re: How to ENABLE SQL capturing???

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

Jonathan Ellis wrote:
> On 8/10/07, Joshua D. Drake <jd@xxxxxxxxxxxxxxxxx> 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-----

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
       message can get through to the mailing list cleanly

[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux