pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedMemory taken by FSM_relations
7+ messages / 5 participants
[nested] [flat]
* Memory taken by FSM_relations
@ 2003-02-24 18:28 Josh Berkus <josh@agliodbs.com>
0 siblings, 2 replies; 7+ messages in thread
From: Josh Berkus @ 2003-02-24 18:28 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Memory taken by FSM_relations
@ 2003-02-24 19:11 Joe Conway <mail@joeconway.com>
parent: Josh Berkus <josh@agliodbs.com>
1 sibling, 3 replies; 7+ messages in thread
From: Joe Conway @ 2003-02-24 19:11 UTC (permalink / raw)
To: Josh Berkus <josh@agliodbs.com>; +Cc: pgsql-performance
Josh Berkus wrote:
> 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.
I don't recall (and cannot find in my sent mail) ever making that
guesstimate. Can you provide some context?
Joe
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Memory taken by FSM_relations
@ 2003-02-24 19:25 Josh Berkus <josh@agliodbs.com>
parent: Joe Conway <mail@joeconway.com>
2 siblings, 0 replies; 7+ messages in thread
From: Josh Berkus @ 2003-02-24 19:25 UTC (permalink / raw)
To: Joe Conway <mail@joeconway.com>; +Cc: pgsql-performance
Joe,
> I don't recall (and cannot find in my sent mail) ever making that
> guesstimate. Can you provide some context?
Yeah, hold on ... hmmm ... no, your e-mail did not provide a figure. Sorry!
Maybe I got it from Neil?
In any case, it can't be the right figure ...
--
Josh Berkus
Aglio Database Solutions
San Francisco
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Memory taken by FSM_relations
@ 2003-02-24 19:34 scott.marlowe <scott.marlowe@ihs.com>
parent: Joe Conway <mail@joeconway.com>
2 siblings, 1 reply; 7+ messages in thread
From: scott.marlowe @ 2003-02-24 19:34 UTC (permalink / raw)
To: Joe Conway <mail@joeconway.com>; +Cc: Josh Berkus <josh@agliodbs.com>; pgsql-performance
On Mon, 24 Feb 2003, Joe Conway wrote:
> Josh Berkus wrote:
> > 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.
>
> I don't recall (and cannot find in my sent mail) ever making that
> guesstimate. Can you provide some context?
If I remember right, it was 6 BYTES per max fsm pages... not kbytes.
That sounds about right anyway.
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Memory taken by FSM_relations
@ 2003-02-24 19:35 Larry Rosenman <ler@lerctr.org>
parent: Joe Conway <mail@joeconway.com>
2 siblings, 0 replies; 7+ messages in thread
From: Larry Rosenman @ 2003-02-24 19:35 UTC (permalink / raw)
To: Joe Conway <mail@joeconway.com>; Josh Berkus <josh@agliodbs.com>; +Cc: pgsql-performance
--On Monday, February 24, 2003 11:11:34 -0800 Joe Conway
<mail@joeconway.com> wrote:
> Josh Berkus wrote:
>> 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.
>
> I don't recall (and cannot find in my sent mail) ever making that
> guesstimate. Can you provide some context?
It may be 6 **BYTES** per max_fsm_pages.
>
> Joe
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Memory taken by FSM_relations
@ 2003-02-24 19:55 Josh Berkus <josh@agliodbs.com>
parent: scott.marlowe <scott.marlowe@ihs.com>
0 siblings, 0 replies; 7+ messages in thread
From: Josh Berkus @ 2003-02-24 19:55 UTC (permalink / raw)
To: scott.marlowe <scott.marlowe@ihs.com>; Joe Conway <mail@joeconway.com>; +Cc: pgsql-performance
Scott,
> If I remember right, it was 6 BYTES per max fsm pages... not kbytes.
> That sounds about right anyway.
So, does it come out of Shared_buffers or add to it?
--
Josh Berkus
Aglio Database Solutions
San Francisco
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Memory taken by FSM_relations
@ 2003-02-24 20:17 Tom Lane <tgl@sss.pgh.pa.us>
parent: Josh Berkus <josh@agliodbs.com>
1 sibling, 0 replies; 7+ messages in thread
From: Tom Lane @ 2003-02-24 20:17 UTC (permalink / raw)
To: Josh Berkus <josh@agliodbs.com>; +Cc: pgsql-performance
Josh Berkus <josh@agliodbs.com> writes:
> 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?
In addition to. Basically max_fsm_pages and max_fsm_relations are used
to ratchet up the postmaster's initial shared memory request to the kernel.
> Further, Joe Conway gave me a guesstimate of 6k per max_fsm_pages
> which seems rather high ...
Quite ;-). The correct figure is six bytes per fsm_page slot, and
I think about forty bytes per fsm_relation slot (recent versions of
postgresql.conf mention the multipliers, although for some reason
the Admin Guide does not).
regards, tom lane
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2003-02-24 20:17 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-02-24 18:28 Memory taken by FSM_relations Josh Berkus <josh@agliodbs.com>
2003-02-24 19:11 ` Joe Conway <mail@joeconway.com>
2003-02-24 19:25 ` Josh Berkus <josh@agliodbs.com>
2003-02-24 19:34 ` scott.marlowe <scott.marlowe@ihs.com>
2003-02-24 19:55 ` Josh Berkus <josh@agliodbs.com>
2003-02-24 19:35 ` Larry Rosenman <ler@lerctr.org>
2003-02-24 20:17 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox