X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 8A33DD9727 for ; Mon, 26 Sep 2005 14:38:17 -0300 (ADT) 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 50379-09 for ; Mon, 26 Sep 2005 17:38:11 +0000 (GMT) Received: from flake.decibel.org (flake.decibel.org [67.100.216.10]) by svr1.postgresql.org (Postfix) with ESMTP id 975E4D96C5 for ; Mon, 26 Sep 2005 14:38:08 -0300 (ADT) Received: by flake.decibel.org (Postfix, from userid 1001) id 3CDF115232; Mon, 26 Sep 2005 17:38:09 +0000 (GMT) Date: Mon, 26 Sep 2005 12:38:09 -0500 From: "Jim C. Nasby" To: Gourish Singbal Cc: Hannes Dorbath , pgsql-admin@postgresql.org Subject: Re: vacuum message Message-ID: <20050926173808.GJ30974@pervasive.com> References: <674d1f8a05092606583266eb3a@mail.gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <674d1f8a05092606583266eb3a@mail.gmail.com> X-Operating-System: FreeBSD 4.11-RELEASE-p10 i386 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.9i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.005 required=5 tests=[AWL=0.005] X-Spam-Level: X-Archive-Number: 200509/291 X-Sequence-Number: 19028 On Mon, Sep 26, 2005 at 07:28:30PM +0530, Gourish Singbal wrote: > Thats a good Idea. > My output after full vaccum is :- > INFO: free space map: 9 relations, 114736 pages stored; 76592 total pages > needed > DETAIL: Allocated FSM size: 1000 relations + 300000 pages = 1856 kB shared > memory. > VACUUM > I just have a Question: > Is the allocate pages 300000 okey ?. OR do i need to decrease it to 100000 ? > regards Downside: you're burning extra memory, to the tune of 6 bytes per page. Downside: there's some additional overhead in maintaining a larger FSM Upside: you have room to grow, as well as to accommodate occasional bursts of update activity Both downsides are pretty minor, I'd say just stick with what you've got. -- Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461