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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-bugs by date

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