Received: from localhost (unknown [200.46.204.184]) by developer.postgresql.org (Postfix) with ESMTP id 9C0122E0033 for ; Tue, 29 Apr 2008 10:16:15 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 93281-02 for ; Tue, 29 Apr 2008 10:15:56 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from yw-out-2324.google.com (yw-out-2324.google.com [74.125.46.28]) by developer.postgresql.org (Postfix) with ESMTP id D960B2E0032 for ; Tue, 29 Apr 2008 10:16:03 -0300 (ADT) Received: by yw-out-2324.google.com with SMTP id 5so1675715ywb.73 for ; Tue, 29 Apr 2008 06:16:00 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=XqkJzHByVOM+3L9a+roDayqFkm11GK60UbK7zv3wYw0=; b=KwdB+zhygv099RfW/YyHulGSIjzdhG5flZX9X2zty5+G8XQ6SpANAj+gsLzdEV/IKTltqGexDQ52mKeF6dlldagPLdxFDDo6ot9dbsGXgQRo7t+7lBo7Gxvi1dLWndBLc+y72GVSNp6CMCUPe4BEu7sL6e5vlNtxsWhMioj+J94= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=BLzmviqpBlpdg8HRyvTt4rmXBMxRHMle+5MmDmzgBm4/2qAkXTX7ceIjP4qcDPi/u+0cfz7lS/Gb5vvcHGvtEDGfx1h5+/UiQl61+po2a/mZpvHI9z9TZKp+VwR5bUouEOsu1y2di1MvsW0t/R5L5lkaufl6g2x+duv3++yagSI= Received: by 10.150.84.17 with SMTP id h17mr5008082ybb.201.1209474960391; Tue, 29 Apr 2008 06:16:00 -0700 (PDT) Received: by 10.151.84.7 with HTTP; Tue, 29 Apr 2008 06:16:00 -0700 (PDT) Message-ID: <2e78013d0804290616y78f3825alf8595e5043dc8385@mail.gmail.com> Date: Tue, 29 Apr 2008 18:46:00 +0530 From: "Pavan Deolasee" To: "Gauri Kanekar" Subject: Re: Replication Syatem Cc: "Greg Smith" , pgsql-performance@postgresql.org In-Reply-To: <7e4ba9550804290612v30ef053bj6a7c2fe5600aba27@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <7e4ba9550804280638ie81dc23w472785c83cd38fcf@mail.gmail.com> <7e4ba9550804280705q43c51e66l104a5ff9272bbd4d@mail.gmail.com> <20080428162243.GN2970@commandprompt.com> <7e4ba9550804282246p73c62fc6y5e7cb7dda55a6b50@mail.gmail.com> <7e4ba9550804290405i4c0d3a57x1640239c9995c13@mail.gmail.com> <2e78013d0804290425n402f5e94i90bc7206aeefffdc@mail.gmail.com> <7e4ba9550804290559t7948d549j7e506154c0b1ed38@mail.gmail.com> <2e78013d0804290609k3bd2aa94q8c6b1c9763e2355a@mail.gmail.com> <7e4ba9550804290612v30ef053bj6a7c2fe5600aba27@mail.gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.544 tagged_above=0 required=5 tests=AWL=-1.355, FS_REPLICA=1.179, SARE_SPEC_REPLICA=0.72 X-Spam-Level: X-Archive-Number: 200804/439 X-Sequence-Number: 29932 On Tue, Apr 29, 2008 at 6:42 PM, Gauri Kanekar wrote: > Thats how our updates works. > We usually tend to touch the same row many times a day. > Then start with a non-100 fillfactor. I would suggest something like 80 and then adjust based on the testing. Since you are anyways have a update intensive setup, leaving free space in the heap won't harm you much in the long term. Thanks, Pavan -- Pavan Deolasee EnterpriseDB http://www.enterprisedb.com