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.
In response to
pgsql-performance by date
|Next:||From: Brad Nicholson||Date: 2009-11-19 18:57:51|
|Subject: Re: SSD + RAID|
|Previous:||From: Craig James||Date: 2009-11-19 18:12:30|
|Subject: FSM - per database or per installation?|