From: | "Martin Dillard" <martin(at)edusoftinc(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Linux max on shared buffers? |
Date: | 2002-07-10 17:45:14 |
Message-ID: | 029601c22839$8c091e90$0301a8c0@market |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
We are trying to throw a lot of memory at PostgreSQL to try to boost
performance. In an attempt to put our entire database into memory, I want to
allocate 2 to 3 GB out of 4 GB on a dual processor server running Red Hat
Linux 7.3 and PostgreSQL 7.2.1. We only expect 4 or 5 concurrent backends.
When I try to allocate 2 GB or more, I get the following error when I try to
start PostgreSQL (after setting kernel.shmall and kernel.shmmax
appropriately):
IpcMemoryCreate: shmat(id=163840) failed: Cannot allocate memory
I can safely allocate a little under 2 GB. Is this a Linux upper bound on
how much memory can be allocated to a single program? Is there another
kernel parameter besides kernel.shmall and kernel.shmmax that can be set to
allow more memory to be allocated?
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Sullivan | 2002-07-10 17:45:36 | Re: I am being interviewed by OReilly |
Previous Message | Ben | 2002-07-10 17:33:39 | Re: I am being interviewed by OReilly |