Sorry, forgot to mention that: logging_collector = on # Enable capturing of stderr and csvlog
Infact I was thinking of the other way, to switch it off and somehow display the stderr(or syslog) directly on console (rather than writing to a file) to see if it helps. ________________________________ From: Tom Lane <[email protected]> To: A J <[email protected]> Cc: Kevin Grittner <[email protected]>; Scott Marlowe <[email protected]>; [email protected] Sent: Thu, September 2, 2010 3:03:33 PM Subject: Re: [ADMIN] Confused by 'timing' results A J <[email protected]> writes: > The performance as seen from the clients dropped substantially after turning > on > > the extra logging. The numbers were real but the performance dropped > significantly. > All the log related settings in postgresql.conf are below: Hmm, what about logging_collector? (Or it might be called redirect_stderr, depending on which PG version this is.) If it's currently off, see whether turning it on improves matters. regards, tom lane -- Sent via pgsql-admin mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
