Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 38A819FC243 for ; Fri, 18 May 2007 15:57:45 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 03103-06 for ; Fri, 18 May 2007 15:57:36 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id E0B179FC13B for ; Fri, 18 May 2007 15:57:36 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from mail.sotech1.com (mail.sotechinc.us [65.123.22.18]) by svr4.postgresql.org (Postfix) with ESMTP id B2F355AF03B for ; Fri, 18 May 2007 18:57:35 +0000 (GMT) Received: from ehart-mbpro.local ([24.126.61.65]) by mail.sotech1.com with Microsoft SMTPSVC(6.0.3790.3959); Fri, 18 May 2007 14:57:27 -0400 Message-ID: <464DF71C.5010805@gmail.com> Date: Fri, 18 May 2007 14:57:32 -0400 From: Gene Hart User-Agent: Thunderbird 2.0.0.0 (Macintosh/20070326) MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: choosing fillfactor Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 18 May 2007 18:57:27.0845 (UTC) FILETIME=[612A7550:01C7997E] X-TM-AS-Product-Ver: SMEX-7.0.0.1345-3.6.1039-15184.000 X-TM-AS-Result: No--1.136300-4.000000-31 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.136 tagged_above=0 required=5 tests=BAYES_50=0.001, FORGED_RCVD_HELO=0.135 X-Spam-Level: X-Archive-Number: 200705/336 X-Sequence-Number: 24726 I've tried searching the documentation to answer this question but could not find anything. When trying to choose the optimal fillfactor for an index, what is important the number of times the row is updated or the column indexed upon is updated? In my case each row is updated on average about 5 times but for some of the columns with indexes don't change after insertion ever. thanks for any advice