X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id DC65FD1BB15 for ; Mon, 1 Mar 2004 17:30:48 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 11879-07 for ; Mon, 1 Mar 2004 13:30:44 -0400 (AST) Received: from mail.dsvr.co.uk (mail.dsvr.co.uk [212.69.192.8]) by svr1.postgresql.org (Postfix) with ESMTP id 25524D1BA9F for ; Mon, 1 Mar 2004 13:30:43 -0400 (AST) Received: from [212.69.216.20] (helo=dsvr.net) by mail.dsvr.co.uk with esmtp (Exim 4.30) id 1AxrFa-0002WD-8b for pgsql-performance@postgresql.org; Mon, 01 Mar 2004 17:30:42 +0000 Message-ID: <40437341.8060105@dsvr.net> Date: Mon, 01 Mar 2004 17:30:41 +0000 From: Rob Fielding User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.6) Gecko/20040113 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Re: WAL Optimisation - configuration and usage References: <4040E08C.1040408@dsvr.net> <1078015971.24316.9.camel@jester> <4041E430.7010109@dsvr.net> In-Reply-To: <4041E430.7010109@dsvr.net> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/7 X-Sequence-Number: 5863 Further update to my WAL experimentation. pg_xlog files have increased to 81, and checking today up to 84. Currently nothing much going on with the server save a background process running a select every 30 seconds with almost no impact (according to IO from vmstats). This in itself is a good sign - an improvement on running last week, but I'd still like to get clarification on WAL file usage if possible. Log file tailing has nothing more interesting than a whole set of "recycled transaction log file" entries : 2004-03-01 16:01:55 DEBUG: recycled transaction log file 0000007100000017 2004-03-01 16:07:01 DEBUG: recycled transaction log file 0000007100000018 2004-03-01 16:17:14 DEBUG: recycled transaction log file 0000007100000019 2004-03-01 16:22:20 DEBUG: recycled transaction log file 000000710000001A 2004-03-01 16:32:31 DEBUG: recycled transaction log file 000000710000001B 2004-03-01 16:37:36 DEBUG: recycled transaction log file 000000710000001C 2004-03-01 16:47:48 DEBUG: recycled transaction log file 000000710000001D 2004-03-01 16:52:54 DEBUG: recycled transaction log file 000000710000001E 2004-03-01 17:03:05 DEBUG: recycled transaction log file 000000710000001F Looks kinda automated, but the times aren't quite even at around 6-10 minutes apart. cheers, -- Rob Fielding rob@dsvr.net www.dsvr.co.uk Development Designer Servers Ltd