X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 8C3CF9DD602 for ; Thu, 1 Dec 2005 08:00:30 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 27395-02 for ; Thu, 1 Dec 2005 08:00:24 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from vms046pub.verizon.net (vms046pub.verizon.net [206.46.252.46]) by postgresql.org (Postfix) with ESMTP id D91159DD626 for ; Thu, 1 Dec 2005 08:00:25 -0400 (AST) Received: from osgiliath.mathom.us ([70.108.123.101]) by vms046.mailsrvcs.net (Sun Java System Messaging Server 6.2-4.02 (built Sep 9 2005)) with ESMTPA id <0IQT008E4IORBA96@vms046.mailsrvcs.net> for pgsql-performance@postgresql.org; Thu, 01 Dec 2005 06:00:28 -0600 (CST) Received: from localhost (localhost [127.0.0.1]) by osgiliath.mathom.us (Postfix) with ESMTP id 292F66D4879 for ; Thu, 01 Dec 2005 07:00:29 -0500 (EST) Received: from osgiliath.mathom.us ([127.0.0.1]) by localhost (osgiliath [127.0.0.1]) (amavisd-new, port 10024) with LMTP id 24091-03 for ; Thu, 01 Dec 2005 07:00:29 -0500 (EST) Received: by osgiliath.mathom.us (Postfix, from userid 1000) id 023686D4878; Thu, 01 Dec 2005 07:00:28 -0500 (EST) Date: Thu, 01 Dec 2005 07:00:28 -0500 From: Michael Stone Subject: Re: About the relation between fragmentation of file and In-reply-to: <00d101c5f63b$33348330$3cd7adc0@julia> To: pgsql-performance@postgresql.org Mail-followup-to: pgsql-performance@postgresql.org Message-id: <20051201120028.GA7330@mathom.us> MIME-version: 1.0 Content-type: text/plain; charset=us-ascii; format=flowed Content-disposition: inline X-Pgp-Fingerprint: 53 FF 38 00 E7 DD 0A 9C 84 52 84 C5 EE DF 7C 88 X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at mathom.us References: <00d101c5f63b$33348330$3cd7adc0@julia> User-Agent: Mutt/1.5.11 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200512/5 X-Sequence-Number: 15826 On Thu, Dec 01, 2005 at 02:50:56PM +0900, Tatsumi Abe wrote: >Could anyone advise some solutions for this fragmentation problem >without stopping PostgreSQL ? Stop doing VACUUM FULL so often. If your table size is constant anyway you're just wasting time by compacting the table and shrinking it, and encouraging fragmentation as each table file grows then shrinks a little bit each day. Mike Stone