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 DF2973A46D4;
	Thu,  4 Nov 2004 01:15:48 +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 60807-04; Thu,  4 Nov 2004 01:15:44 +0000 (GMT)
Received: from lon-mail.telstra.net (unknown [203.50.2.188])
	by svr1.postgresql.org (Postfix) with ESMTP id 107AA3A46B2;
	Thu,  4 Nov 2004 01:15:46 +0000 (GMT)
Received: from [203.50.0.197] (rsdhcp5.telstra.net [203.50.0.197])
	by lon-mail.telstra.net (8.12.11/8.12.8) with ESMTP id iA41Fkfp031720;
	Thu, 4 Nov 2004 12:15:46 +1100 (EST)
	(envelope-from justin@postgresql.org)
Message-ID: <418982BA.60208@postgresql.org>
Date: Thu, 04 Nov 2004 12:15:38 +1100
From: Justin Clift <justin@postgresql.org>
User-Agent: Mozilla Thunderbird 0.8 (Windows/20040913)
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: "Marc G. Fournier" <scrappy@postgresql.org>
Cc: pgsql-www@postgresql.org
Subject: Re: pg_autovacuum is nice ... but ...
References: <20041103155855.O82047@ganymede.hub.org>
	<41895BDA.1090903@postgresql.org>
	<20041103201625.S82047@ganymede.hub.org>
In-Reply-To: <20041103201625.S82047@ganymede.hub.org>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
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/73
X-Sequence-Number: 5804

Marc G. Fournier wrote:
<snip>
> I posted once asking about that, but got no responses :)
> 
> 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 :(

Hmmmm, what are the fsm settings for that postgresql.conf?

:)

Regards and best wishes,

Justin Clift


> ----
> Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
> Email: scrappy@hub.org           Yahoo!: yscrappy              ICQ: 7615664