Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 1AEE46325EB for ; Thu, 2 Sep 2010 16:21:34 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 42019-03 for ; Thu, 2 Sep 2010 19:21:26 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from n4-vm1.bullet.mail.gq1.yahoo.com (n4-vm1.bullet.mail.gq1.yahoo.com [67.195.9.86]) by mail.postgresql.org (Postfix) with SMTP id 685246310AC for ; Thu, 2 Sep 2010 16:21:26 -0300 (ADT) Received: from [67.195.9.81] by n4.bullet.mail.gq1.yahoo.com with NNFMP; 02 Sep 2010 19:21:25 -0000 Received: from [98.137.27.218] by t1.bullet.mail.gq1.yahoo.com with NNFMP; 02 Sep 2010 19:21:25 -0000 Received: from [127.0.0.1] by omp128.mail.gq1.yahoo.com with NNFMP; 02 Sep 2010 19:21:25 -0000 X-Yahoo-Newman-Property: ymail-5 X-Yahoo-Newman-Id: 254198.61395.bm@omp128.mail.gq1.yahoo.com Received: (qmail 38734 invoked by uid 60001); 2 Sep 2010 19:21:24 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1283455284; bh=+zW4bJiXwKOtFye55AxUhWqakMGczJm6caa/wtkXcl8=; h=Message-ID:X-YMail-OSG:Received:X-Mailer:References:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type; b=kKsWz6Y1HocMzqppz9RuOLD6iIQa2j4evDlfbTYqkRbckdeIY26fWPh9as1zYGUjWZJS82vJMHnJet0IKH5rJSJYvaqOnsCwYRUdiuJWgV/oVkRfNTOEmppx8Mv4U1awqvicJ1WaiPcaed2/v6rAysuUNl6Ak8N19mS9QHKiBmA= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:X-YMail-OSG:Received:X-Mailer:References:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type; b=JzIC/pPLxNpmrLieolDoNxEi2pEuRjdaqs95HvSu6uREHCn2rzHXnds+CmTH0M/304CiuPb052hTsV4oGd252YsHFgI4A5pmuC1NFpWRd9W0FnhSX/ousUh4gvDj8rL+ps8kYuA/0zRpihEHua/IQ44HP8llE9ggeBEkYvFqLJs=; Message-ID: <555672.38356.qm@web120013.mail.ne1.yahoo.com> X-YMail-OSG: dwDivLEVM1nexhVIaldpXYCGYuxGdNqEvdvX4_9nF0fjcmI oN2vor0kivoIZdcWX8g0OHmS3nf_.9mGcSRz30lgNzP_2qZiVVol_3KVxkdc pJyh.3rSWsoBOwA0wpOS94S9S0HZk1SVDTnrWgvAlZa9B_wRineCracuFouP yFHDueWlj5PMNajqxR_7SC_5kUyvIBo43tUH8125eH1UNvJ71bgk1z3Mcm9. NJsl.tIDoPyjXuTEVrw-- Received: from [68.36.215.11] by web120013.mail.ne1.yahoo.com via HTTP; Thu, 02 Sep 2010 12:21:24 PDT X-Mailer: YahooMailRC/470 YahooMailWebService/0.8.105.279950 References: <788866.21140.qm@web120020.mail.ne1.yahoo.com> <4C7D00330200002500034ED2@gw.wicourts.gov> <19320.56933.qm@web120013.mail.ne1.yahoo.com> <529329.89885.qm@web120007.mail.ne1.yahoo.com> <4C7F8F2A0200002500035037@gw.wicourts.gov> <294404.58402.qm@web120007.mail.ne1.yahoo.com> <4C7FA72C0200002500035095@gw.wicourts.gov> <458444.29196.qm@web120007.mail.ne1.yahoo.com> <6595.1283455062@sss.pgh.pa.us> Date: Thu, 2 Sep 2010 12:21:24 -0700 (PDT) From: A J Subject: Re: Confused by 'timing' results To: Tom Lane Cc: Kevin Grittner , Scott Marlowe , pgsql-admin@postgresql.org In-Reply-To: <6595.1283455062@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-269298238-1283455284=:38356" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.909 tagged_above=-10 required=5 tests=BAYES_00=-1.9, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201009/30 X-Sequence-Number: 35574 --0-269298238-1283455284=:38356 Content-Type: text/plain; charset=us-ascii 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 To: A J Cc: Kevin Grittner ; Scott Marlowe ; pgsql-admin@postgresql.org Sent: Thu, September 2, 2010 3:17:42 PM Subject: Re: [ADMIN] Confused by 'timing' results A J 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 --0-269298238-1283455284=:38356 Content-Type: text/html; charset=us-ascii
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

--0-269298238-1283455284=:38356--