X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id DBFD68B9F02 for ; Tue, 8 Feb 2005 20:32:31 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 74618-03 for ; Tue, 8 Feb 2005 20:32:15 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id D4C8A8B9E00 for ; Tue, 8 Feb 2005 20:32:16 +0000 (GMT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j18KWFio009899; Tue, 8 Feb 2005 15:32:15 -0500 (EST) To: "Ben Young" Cc: pgsql-performance@postgresql.org Subject: Re: Slow Restoration of a template1 Database (ALTER GROUP) In-reply-to: <41A1CBC76FDECC42B67946519C6677A901D301FE@pippin.int.etrials.com> References: <41A1CBC76FDECC42B67946519C6677A901D301FE@pippin.int.etrials.com> Comments: In-reply-to "Ben Young" message dated "Tue, 08 Feb 2005 15:08:50 -0500" Date: Tue, 08 Feb 2005 15:32:14 -0500 Message-ID: <9898.1107894734@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200502/127 X-Sequence-Number: 10456 "Ben Young" writes: > Is the "index bloat" prevented/reduced in newer versions of Postgres? Depends on what's causing it. Have you been inventing alphabetically greater group names and getting rid of smaller names over time? If so, this is a known problem that should be fixed in 7.4. The 7.4 release notes say: In previous releases, B-tree index pages that were left empty because of deleted rows could only be reused by rows with index values similar to the rows originally indexed on that page. In 7.4, VACUUM records empty index pages and allows them to be reused for any future index rows. regards, tom lane