Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id A12219FC316 for ; Thu, 18 Oct 2007 15:01:08 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 12264-05 for ; Thu, 18 Oct 2007 15:01:01 -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 212579FC30A for ; Thu, 18 Oct 2007 15:01:04 -0300 (ADT) Received: from dba5.int.libertyrms.com ([10.1.3.44]) by mail.libertyrms.com with esmtp (Exim 4.22) id 1IiZg6-0008S0-G2; Thu, 18 Oct 2007 14:01:02 -0400 Subject: Re: BGWRITER in Postgres 8.2 From: Brad Nicholson To: Mark Steben Cc: pgsql-admin@postgresql.org In-Reply-To: <012801c8118b$f1296f50$b501a8c0@D1RPQZB1> References: <012801c8118b$f1296f50$b501a8c0@D1RPQZB1> Content-Type: text/plain Date: Thu, 18 Oct 2007 14:01:02 -0400 Message-Id: <1192730462.6131.34.camel@bnicholson-desktop> Mime-Version: 1.0 X-Mailer: Evolution 2.10.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-Archive-Number: 200710/178 X-Sequence-Number: 27092 On Thu, 2007-10-18 at 09:36 -0400, Mark Steben wrote: > I would like to test the new components of 8.2 as we upgrade from 7.4 > next month. > > Is there any way to verify that the background writer is operational? Define operational. If you turn it on, it should be operational. Testing whether it is doing what it needs to for your application is a whole other ball game. You need to do some serious benchmarking of your application to figure that out. > > -- Brad Nicholson 416-673-4106 Database Administrator, Afilias Canada Corp.