From: A J <s5aly@yahoo.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Kevin Grittner <Kevin.Grittner@wicourts.gov>
Cc: Scott Marlowe <scott.marlowe@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Confused by 'timing' results
Date: Fri, 3 Sep 2010 15:57:18 -0700 (PDT)
Message-ID: <694437.40392.qm@web120010.mail.ne1.yahoo.com> (raw)
Just to give an update, changing pg_log to a different drive that is write cache
enabled (and to further make it fast, kept it data=writeback), helped quite a
bit.
The average time for several clients hitting concurrently was 15ms each for
east-coast as well as west-coast clients. Still some impact of network is still
at play as the time taken directly on database server was much less at 10ms.
Not logging at all is still better (the time on database with
log_min_duration=-1, is 5.4ms) but putting the log on a different drive adds
only minimal overhead and ability to measure query time reasonably by discarding
most of the network variance.
________________________________
From: A J <s5aly@yahoo.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Kevin Grittner <Kevin.Grittner@wicourts.gov>; Scott Marlowe
<scott.marlowe@gmail.com>; pgsql-admin@postgresql.org
Sent: Thu, September 2, 2010 3:21:24 PM
Subject: Re: [ADMIN] Confused by 'timing' results
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@sss.pgh.pa.us>
To: A J <s5aly@yahoo.com>
Cc: Kevin Grittner <Kevin.Grittner@wicourts.gov>; Scott Marlowe
<scott.marlowe@gmail.com>; pgsql-admin@postgresql.org
Sent: Thu, September 2, 2010 3:17:42 PM
Subject: Re: [ADMIN] Confused by 'timing' results
A J <s5aly@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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: s5aly@yahoo.com, tgl@sss.pgh.pa.us, Kevin.Grittner@wicourts.gov, scott.marlowe@gmail.com
Subject: Re: Confused by 'timing' results
In-Reply-To: <694437.40392.qm@web120010.mail.ne1.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox