pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Memory 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>
  2003-02-24 19:11 ` Re: Memory taken by FSM_relations Joe Conway <mail@joeconway.com>
  2003-02-24 20:17 ` Re: Memory taken by FSM_relations Tom Lane <tgl@sss.pgh.pa.us>
  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 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   ` Re: Memory taken by FSM_relations Josh Berkus <josh@agliodbs.com>
  2003-02-24 19:34   ` Re: Memory taken by FSM_relations scott.marlowe <scott.marlowe@ihs.com>
  2003-02-24 19:35   ` Re: Memory taken by FSM_relations Larry Rosenman <ler@lerctr.org>
  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 18:28 Memory taken by FSM_relations Josh Berkus <josh@agliodbs.com>
  2003-02-24 19:11 ` Re: Memory taken by FSM_relations Joe Conway <mail@joeconway.com>
@ 2003-02-24 19:25   ` Josh Berkus <josh@agliodbs.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 18:28 Memory taken by FSM_relations Josh Berkus <josh@agliodbs.com>
  2003-02-24 19:11 ` Re: Memory taken by FSM_relations Joe Conway <mail@joeconway.com>
@ 2003-02-24 19:34   ` scott.marlowe <scott.marlowe@ihs.com>
  2003-02-24 19:55     ` Re: Memory taken by FSM_relations Josh Berkus <josh@agliodbs.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 18:28 Memory taken by FSM_relations Josh Berkus <josh@agliodbs.com>
  2003-02-24 19:11 ` Re: Memory taken by FSM_relations Joe Conway <mail@joeconway.com>
  2003-02-24 19:34   ` Re: Memory taken by FSM_relations scott.marlowe <scott.marlowe@ihs.com>
@ 2003-02-24 19:55     ` Josh Berkus <josh@agliodbs.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 18:28 Memory taken by FSM_relations Josh Berkus <josh@agliodbs.com>
  2003-02-24 19:11 ` Re: Memory taken by FSM_relations Joe Conway <mail@joeconway.com>
@ 2003-02-24 19:35   ` Larry Rosenman <ler@lerctr.org>
  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 18:28 Memory taken by FSM_relations Josh Berkus <josh@agliodbs.com>
@ 2003-02-24 20:17 ` Tom Lane <tgl@sss.pgh.pa.us>
  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