Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 94A971337B3E for ; Fri, 1 Apr 2011 09:46:25 -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 63047-05 for ; Fri, 1 Apr 2011 12:46:07 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from nm12.bullet.mail.ukl.yahoo.com (nm12.bullet.mail.ukl.yahoo.com [217.146.183.186]) by mail.postgresql.org (Postfix) with SMTP id DD5071337BA1 for ; Fri, 1 Apr 2011 09:46:06 -0300 (ADT) Received: from [217.146.183.211] by nm12.bullet.mail.ukl.yahoo.com with NNFMP; 01 Apr 2011 12:46:06 -0000 Received: from [217.146.183.161] by tm4.bullet.mail.ukl.yahoo.com with NNFMP; 01 Apr 2011 12:46:06 -0000 Received: from [127.0.0.1] by omp1002.mail.ukl.yahoo.com with NNFMP; 01 Apr 2011 12:46:06 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 601912.79580.bm@omp1002.mail.ukl.yahoo.com Received: (qmail 12732 invoked by uid 60001); 1 Apr 2011 12:46:04 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.co.uk; s=s1024; t=1301661963; bh=oVhqua+PNZab+lwc/DBI+wjNDgsmbZ0SBxKmkIv3Jv8=; h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=Vig66dL2S5BAglfagK6sNmzIoS2x6CQt89fwx1l4SLBhKgefglEVCl4T4VDBhZxJ0wVP7q577KzstdOm0ROvoDGWKKQNWxYLiD7qsl0CSp39vRMoWv3kmOWI2DsUSQDnSwesF3MMUKxrS0rvd3Q/UHVrGBmHo0YVw0jCDkprl1M= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.co.uk; h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=CkcB9r+26nPM1vdi3z/imiBeCkYdDl4oVb3cBD1sacfZOhTpdbjU6ns1OxH327b76ROaELfymh0VPur6mrbnbB0rly3vX/iJPKU1cXzCPr/mJ7DnW3N/KL9NrFkLR+vA9m9V3OMHlw2uiQWMZ7VSYlP3TPLcGo+3GT10UDSILZ8=; Message-ID: <850209.10490.qm@web26006.mail.ukl.yahoo.com> X-YMail-OSG: 10r_uzUVM1kHUTZnmJGjH_u5nBizHz4A3uhsuTTkrup35Ma Clkl3T8t2DC.AF_7x.2puDnRp6snoHDAKmgcNQI858Z60YYSU9VVIZSArYgG e_mz1X1dxtI0LbUHtDdYY4jwnToQDSi_1zAVyBBEZQEpyyjiVgh2tw9CAHXu n24yh09wxhc37k_DIBQb8wnexSQgNvLJueT9tOhrDBeMRsKXi.7eQY0nrsrX NL8JX8jMHs3OjdCYuhuu8yw5YDqg1.9M2yQliRXc8ORB6Xu7Kb_H4u89F6Bs 5jzsS2f7KHqTmioJWnZXRSR952ijjzrgTp47bXA71P.6eyuLIBRN_WriDRto jRrWHhE16P0olEIDWa_fE5delMbvZ Received: from [83.100.146.195] by web26006.mail.ukl.yahoo.com via HTTP; Fri, 01 Apr 2011 13:46:03 BST X-Mailer: YahooMailClassic/12.0.2 YahooMailWebService/0.8.109.295617 Date: Fri, 1 Apr 2011 13:46:03 +0100 (BST) From: Glyn Astill Subject: Index fillfactor changed in pg9? To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.011 tagged_above=-10 required=5 tests=BAYES_40=-0.001, FREEMAIL_FROM=0.001, RCVD_IN_DNSWL_NONE=-0.0001, RFC_ABUSE_POST=0.001, T_TO_NO_BRKTS_FREEMAIL=0.01 X-Spam-Level: X-Archive-Number: 201104/12 X-Sequence-Number: 37193 Hey Guys,=0A=0AJust testing some new hardware on 9.0.3 and have restored on= e of our dumps from 8.4.7. What I'm seeing is although table sizes are the= same, indexes are a lot bigger, approx 50%.=0A=0AI've done a search and so= far can't find anything, but have default fillfactors changed? Or is it so= mething else?=0A=0AThanks=0AGlyn