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

Re: FSM - per database or per installation?

From: Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
To: Craig James <craig_james(at)emolecules(dot)com>
Cc: pgsql-performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: FSM - per database or per installation?
Date: 2009-11-19 18:33:16
Message-ID: 4B058F6C.3030100@enterprisedb.com (view raw or flat)
Thread:
Lists: pgsql-performance
Craig James wrote:
> Are the FSM parameters for each database, or the entire Postgres
> system?  In other words, if I have 100 databases, do I need to increase
> max_fsm_pages and max_fsm_relations by a factor of 100, or keep them the
> same as if I just have one database?
> 
> I suspect they're per-database, i.e. as I add databases, I don't have to
> increase the FSM parameters, but the documentation isn't 100% clear on
> this point.

It's per cluster, ie *not* per-database.

The parameter is gone in 8.4, BTW.

-- 
  Heikki Linnakangas
  EnterpriseDB   http://www.enterprisedb.com

In response to

Responses

pgsql-performance by date

Next:From: Brad NicholsonDate: 2009-11-19 18:57:51
Subject: Re: SSD + RAID
Previous:From: Craig JamesDate: 2009-11-19 18:12:30
Subject: FSM - per database or per installation?

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