Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id DA46E9FA2CB for ; Thu, 13 Sep 2007 14:58:23 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 79361-06 for ; Thu, 13 Sep 2007 14:58:19 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from mail.libertyrms.com (vgateway.libertyrms.info [207.219.45.62]) by postgresql.org (Postfix) with ESMTP id 148529FA179 for ; Thu, 13 Sep 2007 14:58:20 -0300 (ADT) Received: from dba5.int.libertyrms.com ([10.1.3.44]) by mail.libertyrms.com with esmtp (Exim 4.22) id 1IVsxH-00068X-Uj; Thu, 13 Sep 2007 13:58:19 -0400 Subject: Re: Long Running Commits - Not Checkpoints From: Brad Nicholson To: Greg Smith Cc: pgsql-performance@postgresql.org In-Reply-To: References: <1189692915.8624.22.camel@bnicholson-desktop> Content-Type: text/plain Date: Thu, 13 Sep 2007 13:58:19 -0400 Message-Id: <1189706299.8624.43.camel@bnicholson-desktop> Mime-Version: 1.0 X-Mailer: Evolution 2.8.1 Content-Transfer-Encoding: 7bit X-SA-Exim-Mail-From: bnichols@ca.afilias.info X-SA-Exim-Scanned: No; SAEximRunCond expanded to false X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=AWL=-0.000, BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 200709/257 X-Sequence-Number: 26802 On Thu, 2007-09-13 at 12:12 -0400, Greg Smith wrote: > Since you're probably not monitoring I/O waits and similar statistics on > how the disk array's cache is being used, whether this is happening or not > to you won't be obvious from what the operating system is reporting. A sysadmin looked at cache usage on the disk array. The read cache is being used heavily, and the write cache is not. -- Brad Nicholson 416-673-4106 Database Administrator, Afilias Canada Corp.