Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 3E9DBB5DBD9 for ; Tue, 17 May 2011 10:00:03 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 11678-07 for ; Tue, 17 May 2011 12:59:56 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail-qw0-f46.google.com (mail-qw0-f46.google.com [209.85.216.46]) by mail.postgresql.org (Postfix) with ESMTP id 4977FB5D800 for ; Tue, 17 May 2011 09:59:56 -0300 (ADT) Received: by qwk3 with SMTP id 3so225149qwk.19 for ; Tue, 17 May 2011 05:59:56 -0700 (PDT) Received: by 10.224.9.203 with SMTP id m11mr411724qam.360.1305637195943; Tue, 17 May 2011 05:59:55 -0700 (PDT) Received: from AnibalVAIO (host-3-181.a3.cmm.com.py [190.2.194.181]) by mx.google.com with ESMTPS id k2sm291927qcu.43.2011.05.17.05.59.52 (version=TLSv1/SSLv3 cipher=OTHER); Tue, 17 May 2011 05:59:54 -0700 (PDT) From: "Anibal David Acosta" To: Subject: Fill Factor Date: Tue, 17 May 2011 08:59:50 -0400 Message-ID: <003201cc1492$514419a0$f3cc4ce0$@devshock.com> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Outlook 14.0 Thread-Index: AcwUkZpI1RYyfRsORx24JZs3T/PJrw== Content-Language: es-py X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201105/258 X-Sequence-Number: 43767 Hello, How fillfactor impact performance of query? I have two cases, One is a operational table, for each insert it have an update, this table must have aprox. 1.000 insert per second and 1.000 update per second (same inserted row) Is necessary to change the fill factor? The other case is a table that have few insert (statistics) but thousands or millons of update, In this case the fillfactor is not necessary to change? Thanks!