From: | Craig James <craig_james(at)emolecules(dot)com> |
---|---|
To: | Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com> |
Cc: | pgsql-performance <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: FSM - per database or per installation? |
Date: | 2009-12-24 01:38:48 |
Message-ID: | 4B32C628.1020202@emolecules.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Heikki Linnakangas wrote:
> 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.
Hmmm ... it seems I have an impossible problem. I have ~250 databases each with about 2500 relations (as in "select count(1) from pg_class where relname not like 'pg_%'"). That makes roughly 625,000 relations.
But ... for max_fsm_pages, the Postgres manual says, "This setting must be at least 16 * max_fsm_relations. The default is chosen by initdb depending on the amount of available memory, and can range from 20k to 200k pages."
So max_fsm_pages should be 16*625000, or 10,000,000 ... except that the limit is 200,000. Or is it only the *default* that can be 200,000 max, but you can override and set it to any number you like?
It appears that Postgres 8.3 and earlier can't do garbage collection on a configuration like mine. Do I misunderstand something?
> The parameter is gone in 8.4, BTW.
Both max_fsm_relations and max_fsm_pages?
Thanks,
Craig
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Marlowe | 2009-12-24 02:03:23 | Re: FSM - per database or per installation? |
Previous Message | Greg Smith | 2009-12-24 00:26:06 | Re: hardware priority for an SSD database? |