Received: from localhost (unknown [200.46.204.184]) by developer.postgresql.org (Postfix) with ESMTP id AA8332E0044 for ; Wed, 30 Apr 2008 10:38: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 32943-05 for ; Wed, 30 Apr 2008 10:38:04 -0300 (ADT) Received: from mx1.hub.org (mx1.hub.org [200.46.208.106]) by developer.postgresql.org (Postfix) with ESMTP id 7F7242E003B for ; Wed, 30 Apr 2008 10:38:12 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from mail01.enterprisedb.com (webmail.enterprisedb.com [63.246.7.168]) by mx1.hub.org (Postfix) with ESMTP id 8E6E8B07703 for ; Wed, 30 Apr 2008 10:38:06 -0300 (ADT) thread-index: AciqxyyH3LNpR6AqS8WWitfIL8QlaQ== Content-Class: urn:content-classes:message Importance: normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.4133 Received: from [172.24.32.184] ([62.232.55.118]) by mail01.enterprisedb.com over TLS secured channel with Microsoft SMTPSVC(6.0.3790.3959); Wed, 30 Apr 2008 09:36:18 -0400 Message-ID: <481875A1.4060502@enterprisedb.com> Date: Wed, 30 Apr 2008 14:35:29 +0100 From: "Heikki Linnakangas" Organization: EnterpriseDB User-Agent: Mozilla-Thunderbird 2.0.0.9 (X11/20080110) MIME-Version: 1.0 To: "Craig Ringer" Cc: "Gauri Kanekar" , "Shane Ambler" , "Alvaro Herrera" , "Greg Smith" , Subject: Re: Replication Syatem References: <7e4ba9550804280638ie81dc23w472785c83cd38fcf@mail.gmail.com> <7e4ba9550804280705q43c51e66l104a5ff9272bbd4d@mail.gmail.com> <20080428162243.GN2970@commandprompt.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> In-Reply-To: <48186315.6050601@postnewspapers.com.au> Content-Type: text/plain; format=flowed; charset="ISO-8859-1" Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 30 Apr 2008 13:36:19.0062 (UTC) FILETIME=[2BD48160:01C8AAC7] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200804/464 X-Sequence-Number: 29957 Craig Ringer wrote: > Heikki Linnakangas wrote: > >> Did you dump and reload the table after setting the fill factor? It >> only affects newly inserted data. > > VACUUM FULL or CLUSTER should do the job too, right? After all, they > recreate the table so they must take the fillfactor into account. CLUSTER, yes. VACUUM FULL won't move tuples around just to make room for the fillfactor. -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com