Skip site navigation (1) Skip section navigation (2)

determining max_fsm_pages

From: Patrick Hatcher <pathat(at)comcast(dot)net>
To: pgsql-performance(at)postgresql(dot)org
Subject: determining max_fsm_pages
Date: 2004-10-29 14:04:53
Message-ID: 41824E05.8000903@comcast.net (view raw or flat)
Thread:
Lists: pgsql-performance
Pg: 7.4.5
8G ram
200G RAID5

I have my  fsm set as such:
max_fsm_pages = 300000          # min max_fsm_relations*16, 6 bytes each
max_fsm_relations = 500         # min 100, ~50 bytes each


I just did a vacuum full on one table and saw this result:
INFO:  analyzing "cdm.cdm_fed_agg_purch"
INFO:  "cdm_fed_agg_purch": 667815 pages, 3000 rows sampled, 52089570 
estimated total rows


My question is this:  I have about 8 databases running on this server.  
When I do a vacuum full on each of these databases, there is a INFO 
section that I assume is the total pages used for that database.  Should 
add ALL these individual pages together and pad the total and use this 
as my new max_fsm_pages?  Should I do the same thing with max_fsm_relations?

TIA
Patrick

Responses

pgsql-performance by date

Next:From: Tatsuo IshiiDate: 2004-10-29 14:31:51
Subject: Re: determining max_fsm_pages
Previous:From: Jim C. NasbyDate: 2004-10-28 23:54:30
Subject: Re: Sequential Scan with LIMIT

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group