FSM - per database or per installation?

From: Craig James <craig_james(at)emolecules(dot)com>
To: pgsql-performance <pgsql-performance(at)postgresql(dot)org>
Subject: FSM - per database or per installation?
Date: 2009-11-19 18:12:30
Message-ID: 4B058A8E.4050406@emolecules.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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.

Thanks,
Craig

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Heikki Linnakangas 2009-11-19 18:33:16 Re: FSM - per database or per installation?
Previous Message Anton Rommerskirchen 2009-11-19 18:01:14 Re: SSD + RAID