pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Patrick Hatcher <pathat@comcast.net>
To: pgsql-performance@postgresql.org
Subject: determining max_fsm_pages
Date: Fri, 29 Oct 2004 07:04:53 -0700
Message-ID: <41824E05.8000903@comcast.net> (raw)

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



view thread (3+ messages)  latest in thread

Message-ID: <41824E05.8000903@comcast.net>
Permalink:  ../41824E05.8000903@comcast.net/
Also on:    postgresql.org/message-id/41824E05.8000903@comcast.net

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: pathat@comcast.net
  Subject: Re: determining max_fsm_pages
  In-Reply-To: <41824E05.8000903@comcast.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox