Received: from localhost (unknown [200.46.204.184])
	by developer.postgresql.org (Postfix) with ESMTP id 609162E0052
	for <pgsql-performance-postgresql.org@developer.postgresql.org>;
	Thu, 17 Apr 2008 05:37:38 -0300 (ADT)
Received: from developer.postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024)
	with ESMTP id 14669-03
	for <pgsql-performance-postgresql.org@developer.postgresql.org>;
	Thu, 17 Apr 2008 05:37:30 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.5
Received: from cptwks26.careerjunction.local (unknown [196.212.105.173])
	by developer.postgresql.org (Postfix) with ESMTP id 26CD92E0037
	for <pgsql-performance@postgresql.org>;
	Thu, 17 Apr 2008 05:37:31 -0300 (ADT)
Received: from [127.0.0.1] (localhost [127.0.0.1])
	by cptwks26.careerjunction.local (Postfix) with ESMTP id A304AB7BC7;
	Thu, 17 Apr 2008 10:37:25 +0200 (SAST)
Message-ID: <48070C45.8010706@careerjunction.co.za>
Date: Thu, 17 Apr 2008 10:37:25 +0200
From: Adrian Moisey <adrian@careerjunction.co.za>
User-Agent: Thunderbird 2.0.0.12 (X11/20080227)
MIME-Version: 1.0
To: Richard Huxton <dev@archonet.com>
CC: Bill Moran <wmoran@collaborativefusion.com>,
	pgsql-performance@postgresql.org
Subject: Re: db size
References: <4802F9E4.3000704@careerjunction.co.za>
	<op.t9lf4tvrcigqcu@apollo13.peufeu.com>
	<48032237.4040604@careerjunction.co.za>
	<op.t9lgusticigqcu@apollo13.peufeu.com>
	<4803276C.2090901@careerjunction.co.za>
	<op.t9lh5em8cigqcu@apollo13.peufeu.com>
	<48045A32.3010607@careerjunction.co.za>
	<20080415071222.36b2e8eb.wmoran@collaborativefusion.com>
	<4806EE1A.8010400@careerjunction.co.za>
	<48070708.4060605@archonet.com>
In-Reply-To: <48070708.4060605@archonet.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200804/227
X-Sequence-Number: 29720

Hi

> You are tracking ~ 4.6 million pages and have space to track ~ 15.5 
> million, so that's fine. You are right up against your limit of 
> relations (tables, indexes etc) being tracked though - 1200. You'll 
> probably want to increase max_fsm_relations - see manual for details 
> (server configuration / free space map).

That is helpful, thanks.

I did a grep on the output to find out more about the max_fsm_relations:

INFO:  free space map contains 2333562 pages in 832 relations
INFO:  free space map contains 3012404 pages in 544 relations
INFO:  free space map contains 3012303 pages in 654 relations
INFO:  free space map contains 3012345 pages in 669 relations
INFO:  free space map contains 3012394 pages in 678 relations
INFO:  free space map contains 3017248 pages in 717 relations
INFO:  free space map contains 2860737 pages in 824 relations
INFO:  free space map contains 4667977 pages in 1199 relations
INFO:  free space map contains 3140238 pages in 181 relations
INFO:  free space map contains 3140322 pages in 182 relations
INFO:  free space map contains 3140387 pages in 183 relations
INFO:  free space map contains 3142781 pages in 184 relations

It doesn't go up close to 1200 often... should I still up that value?

-- 
Adrian Moisey
Systems Administrator | CareerJunction | Your Future Starts Here.
Web: www.careerjunction.co.za | Email: adrian@careerjunction.co.za
Phone: +27 21 686 6820 | Mobile: +27 82 858 7830 | Fax: +27 21 686 6842