Benjamin Arai wrote:
A machine with 4GB of memory has the ability to allocate 2GB to
postgres under kenel 2.6. Is the 2GB maximum the sum total of
(work_mem, maitenance_work_mem, and shared_memory) or just
shared_memory?
shared_memory and if I recall correctly that is adjustable but I do
A machine with 4GB
of memory has the ability to allocate 2GB to postgres under kenel 2.6. Is
the 2GB maximum the sum total of (work_mem, maitenance_work_mem, and
shared_memory) or just
shared_memory?
"Ed L." <[EMAIL PROTECTED]> writes:
> But still wondering why 110mb request cannot be satisfied from 2.91gb of =
> free mem or 3.2gb os buffer cache?
Presumably, the shmem segments already in existence are eating almost
all of your kernel SHMMAX limit.
regards, tom lane
-
IpcMemoryCreate:
shmget(key=9099001, size=110002176, 03600) failed: Not enough
space
This error usually means that PostgreSQL's
request for a sharedmemory segment exceeded available memory or swap
space.To reduce the request size (currently 110002176 bytes),
reducePostg
I have an HP ia64 11.23 server with 16gb of
RAM running 6 pgsql clusters. I'm seeing this old error when attempting to
restart a legacy 7.3.4 cluster after a power outage:
./postmaster successfully
startedIpcMemoryCreate: shmget(key=9099001, size=110002176, 03600) fail