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
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 |