Re: FSM - per database or per installation?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

-- 
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux