PostgreSQL 8.4 CentoOS 5.5 I have got WCE=0, on the drive that mounts the data directory with all its subdirectory (including pg_log)
Maybe I should try to mount pg_log to a different drive and have write cache enabled on that one. ________________________________ From: Tom Lane <t...@sss.pgh.pa.us> To: A J <s5...@yahoo.com> Cc: Kevin Grittner <kevin.gritt...@wicourts.gov>; Scott Marlowe <scott.marl...@gmail.com>; pgsql-admin@postgresql.org Sent: Thu, September 2, 2010 3:17:42 PM Subject: Re: [ADMIN] Confused by 'timing' results A J <s5...@yahoo.com> writes: > Do you think changing log_destination to syslog may make a difference It's worth trying alternatives anyway. It is odd that you are seeing such a slowdown when using the collector --- many people push very high log volumes through the collector without problems. What PG version is this exactly, and on what platform? regards, tom lane