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

FSM settings -- how to tell if they are working?

From: Jeff Boes <jboes(at)nexcerpt(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: FSM settings -- how to tell if they are working?
Date: 2003-01-27 18:25:58
Message-ID: b13tfm$2kb7$1@news.hub.org (view raw or flat)
Thread:
Lists: pgsql-admin
We have both test and production databases, about 10 GB total in each.
Recently, I learned about "max_fsm_pages" and "max_fsm_relations". To get
a feel for what changing these settings would do to our production
database, I set the following values in the "test" database:

max_fsm_relations = 100
max_fsm_pages = 350000

but left the production server alone. How can I tell if these new
settings are having any effect?  How can I determine if these numbers are
the best choices?

We perform full vacuums on each of 103 tables every night (including many
very small tables, which exist only to provide references for foreign
keys -- "code tables").

-- 
Jeff Boes                                      vox 616.226.9550 ext 24
Database Engineer                                     fax 616.349.9076
Nexcerpt, Inc.                                 http://www.nexcerpt.com
           ...Nexcerpt... Extend your Expertise

Responses

pgsql-admin by date

Next:From: Gaetano MendolaDate: 2003-01-27 18:38:29
Subject: Re: Replication
Previous:From: Michiel LangeDate: 2003-01-27 18:16:32
Subject: Re: Cannot connect to the database (PG 7.3)

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