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 D4256D1E927 for ; Sun, 29 Feb 2004 13:06: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 82363-07 for ; Sun, 29 Feb 2004 09:06:49 -0400 (AST) Received: from mta03-svc.ntlworld.com (mta03-svc.ntlworld.com [62.253.162.43]) by svr1.postgresql.org (Postfix) with ESMTP id F3143D1E2E6 for ; Sun, 29 Feb 2004 09:06:44 -0400 (AST) Received: from dsvr.net ([81.99.214.194]) by mta03-svc.ntlworld.com (InterMail vM.4.01.03.37 201-229-121-137-20020806) with ESMTP id <20040229130618.RDCG22458.mta03-svc.ntlworld.com@dsvr.net> for ; Sun, 29 Feb 2004 13:06:18 +0000 Message-ID: <4041E430.7010109@dsvr.net> Date: Sun, 29 Feb 2004 13:08:01 +0000 From: Rob Fielding User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.5) Gecko/20031007 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> In-Reply-To: <1078015971.24316.9.camel@jester> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/332 X-Sequence-Number: 5856 Rod Taylor wrote: >>random_page_cost = 0.5 >> >> > >Try a value of 2 for a while. > > > OK thanks Richard and Rod. I've upped this to 2. I think I left this over from a previous play with setttings on my IDE RAID 0 workstation. It seemed to have a good effect being set as a low float so it stuck. I've set it to 2. From another post off list, I've also bumped up max_fsm_relations = 1000 # min 10, fsm max_fsm_pages = 20000 # min 1000, fs vacuum_mem = 32768 # min 1024 as they did seem a little low. I'm hesitant to set them too high at this stage as I'd prefer to keep as much RAM available for runtime at this time. I'm still hoping that perhaps the uber-pgadmin Mr Lane might reply about my WAL issue :) however I'm getting the feeling now the server is running with a much higher level of performance than it has been. Won't know until tomorrow thought. Cheers, -- Rob Fielding Development Designer Servers Ltd