Memory taken by FSM_relations

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Memory taken by FSM_relations
Date: 2003-02-24 18:28:00
Message-ID: 200302241028.00309.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Folks:

I'm not clear on where the memory needed by max_fsm_pages comes from. Is it
taken out of the shared_buffers, or in addition to them?

Further, Joe Conway gave me a guesstimate of 6k per max_fsm_pages which seems
rather high ... in fact, the default settings for this value (10000) would
swamp the memory used by the rest of Postgres. Does anyone have a good
measurment of the memory load imposed by higher FSM settings?

--
Josh Berkus
Aglio Database Solutions
San Francisco

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Robert Treat 2003-02-24 18:30:34 Re: slow query
Previous Message scott.marlowe 2003-02-24 18:11:33 Re: partitioning os swap data log tempdb