X-Original-To: pgsql-www-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 4DFE63A4774; Thu, 4 Nov 2004 03:33:55 +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 81789-03; Thu, 4 Nov 2004 03:33:42 +0000 (GMT) Received: from lakermmtao08.cox.net (lakermmtao08.cox.net [68.230.240.31]) by svr1.postgresql.org (Postfix) with ESMTP id EBBD13A4421; Thu, 4 Nov 2004 03:33:45 +0000 (GMT) Received: from [192.168.0.8] (really [24.136.36.194]) by lakermmtao08.cox.net (InterMail vM.6.01.04.00 201-2131-117-20041022) with ESMTP id <20041104033344.CCVP20400.lakermmtao08.cox.net@[192.168.0.8]>; Wed, 3 Nov 2004 22:33:44 -0500 From: Robert Treat To: "Marc G. Fournier" Subject: Re: pg_autovacuum is nice ... but ... Date: Wed, 3 Nov 2004 22:32:36 -0500 User-Agent: KMail/1.6.2 Cc: Justin Clift , pgsql-www@postgresql.org References: <20041103155855.O82047@ganymede.hub.org> <418982BA.60208@postgresql.org> <20041103214956.L82047@ganymede.hub.org> In-Reply-To: <20041103214956.L82047@ganymede.hub.org> MIME-Version: 1.0 Content-Disposition: inline Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Message-Id: <200411032232.36141.xzilla@users.sourceforge.net> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200411/83 X-Sequence-Number: 5814 On Wednesday 03 November 2004 20:50, Marc G. Fournier wrote: > On Thu, 4 Nov 2004, Justin Clift wrote: > > Marc G. Fournier wrote: > >> Here is a vacuum verbose on gborg's database: > >> > >> INFO: free space map: 1000 relations, 7454 pages stored; 23072 total > >> pages needed > >> DETAIL: Allocated FSM size: 1000 relations + 20000 pages = 178 kB > >> shared memory. > >> and this is portal: > >> > >> INFO: free space map: 1000 relations, 7425 pages stored; 23024 total > >> pages needed > >> DETAIL: Allocated FSM size: 1000 relations + 20000 pages = 178 kB > >> shared memory. > >> > >> so, you tell me ... should I increase them? I haven't been able to find > >> any docs that talk about this :( > > Those numbers don't look right, but I'd say increase your max_fsm_pages to 25000 and your max_fsm_relations to 1250. Don't forget to HUP. -- Robert Treat Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL