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 <tgl@xxxxxxxxxxxxx>
To: A J <s5aly@xxxxxxxxx>
Cc: Kevin Grittner <Kevin.Grittner@xxxxxxxxxxxx>; Scott Marlowe <scott.marlowe@xxxxxxxxx>; pgsql-admin@xxxxxxxxxxxxxx
Sent: Thu, September 2, 2010 3:17:42 PM
Subject: Re: Confused by 'timing' results
A J <s5aly@xxxxxxxxx> 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
