Skip site navigation (1) Skip section navigation (2)

Re: shared_buffers vs. -B flag: 7.4

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: elein(at)varlena(dot)com (elein)
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: shared_buffers vs. -B flag: 7.4
Date: 2005-01-23 19:15:07
Message-ID: 5871.1106507707@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
elein(at)varlena(dot)com (elein) writes:
> However, if you use the -B option on the pg_ctl
> start up, postgres starts up fine.  And
> the shared_buffers value shown by show
> is the higher value.

It behaves as expected for me, in both 7.4 and CVS tip.  Are you sure
your test case wasn't such that the higher -B value in fact worked?
(For instance, maybe you stopped another postmaster that was using some
of the shmem.)

$ postmaster -B 65000
FATAL:  could not create shared memory segment: Not enough space
DETAIL:  Failed system call was shmget(key=5474001, size=543997952, 03600).
HINT:  This error usually means that PostgreSQL's request for a shared memory segment exceeded available memory or swap space. To reduce the request size (currently 543997952 bytes), reduce PostgreSQL's shared_buffers parameter (currently 65000) and/or its max_connections parameter (currently 100).
        The PostgreSQL documentation contains more information about shared memory configuration.
$ 

			regards, tom lane

In response to

Responses

pgsql-bugs by date

Next:From: eleinDate: 2005-01-23 20:28:08
Subject: Re: shared_buffers vs. -B flag: 7.4
Previous:From: eleinDate: 2005-01-23 18:38:27
Subject: shared_buffers vs. -B flag: 7.4

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group