Received: from localhost (unknown [200.46.204.184]) by developer.postgresql.org (Postfix) with ESMTP id EDF3D2E007D for ; Wed, 30 Apr 2008 11:40:37 -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 91210-01-7 for ; Wed, 30 Apr 2008 11:40:23 -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 E72252E008D for ; Wed, 30 Apr 2008 11:39:59 -0300 (ADT) Received: by yw-out-2324.google.com with SMTP id 5so327365ywb.73 for ; Wed, 30 Apr 2008 07:39:58 -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:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=65qPOaHdxVcwtjI4QUxN9Ems4UyGQTQ4HmMmUWXyCOE=; b=b71cW75VzJLI4pryJEBg+U7sts5d3TJuee6iE4EaAgN62RvzRHZfYbbAb3rsiOXnT4CiZ6kf6VjCTR9QdW3eaHbQzgC7eW17CzQAugRMHOrGLCkJPrTNCEwr+vR5OWfXw4pJnUYfFZdhr+7kTuKBQFSrNi1gA64GfBEqCUAr9sg= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=doINFUXQBb+tBSQFDfYt9RFj3Ejz8m9JTEmq39EbLbdPliQ8xJJzecBj0ORmX1/KOupFOc3Id+QeUHd5ETX/PXiJn6x9aqhwm9Q6lbjHA9D/A++rH/4H1g83k/kp8grBQ4PoMvTMl/PS6BdeMCUzyEumNe52kPbflAtdoimfwGw= Received: by 10.150.84.28 with SMTP id h28mr999559ybb.204.1209562571966; Wed, 30 Apr 2008 06:36:11 -0700 (PDT) Received: by 10.151.84.7 with HTTP; Wed, 30 Apr 2008 06:36:12 -0700 (PDT) Message-ID: <2e78013d0804300636x55f2e293n6f729d935a7490f9@mail.gmail.com> Date: Wed, 30 Apr 2008 19:06:12 +0530 From: "Pavan Deolasee" To: "Gauri Kanekar" , pgsql-performance@postgresql.org Subject: Re: Replication Syatem In-Reply-To: <7e4ba9550804300615h241d6d90sfb2c32ae5e5673a8@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> <7e4ba9550804282246p73c62fc6y5e7cb7dda55a6b50@mail.gmail.com> <7e4ba9550804290405i4c0d3a57x1640239c9995c13@mail.gmail.com> <20080429130204.GA5652@alvh.no-ip.org> <4817514A.3060704@Sheeky.Biz> <7e4ba9550804292229x82e74e5y355349866c72245c@mail.gmail.com> <4818494A.2050405@enterprisedb.com> <48186315.6050601@postnewspapers.com.au> <7e4ba9550804300615h241d6d90sfb2c32ae5e5673a8@mail.gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.617 tagged_above=0 required=5 tests=AWL=-1.282, FS_REPLICA=1.179, SARE_SPEC_REPLICA=0.72 X-Spam-Level: X-Archive-Number: 200804/465 X-Sequence-Number: 29958 Please keep list in the loop. On Wed, Apr 30, 2008 at 6:45 PM, Gauri Kanekar wrote: > Hi, > We have recreated the indices with fillfactor set to 80, which has improved HOT > a little, Wait. Did you say, you recreated the indexes with fill factor ? That's no help for HOT. You need to recreate the TABLEs with a fill factor. And as Heikki pointed out, you need to dump and reload, just altering the table won't affect the current data. Thanks, Pavan -- Pavan Deolasee EnterpriseDB http://www.enterprisedb.com