From: | terry(at)greatgulfhomes(dot)com |
---|---|
To: | "'Martin Dillard'" <martin(at)edusoftinc(dot)com>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Linux max on shared buffers? |
Date: | 2002-07-10 18:17:19 |
Message-ID: | 005c01c2283e$07984be0$2766f30a@development.greatgulfhomes.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
How does one increase the SHMMAX? Does it require recompiling the kernel?
Terry Fielder
Network Engineer
Great Gulf Homes / Ashton Woods Homes
terry(at)greatgulfhomes(dot)com
> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org
> [mailto:pgsql-general-owner(at)postgresql(dot)org]On Behalf Of Martin Dillard
> Sent: Wednesday, July 10, 2002 1:45 PM
> To: pgsql-general(at)postgresql(dot)org
> Subject: [GENERAL] Linux max on shared buffers?
>
>
> 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?
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Sullivan | 2002-07-10 18:18:23 | Re: I am being interviewed by OReilly |
Previous Message | Vivek Khera | 2002-07-10 18:15:09 | was there a change in FreeBSD SHM implementation from 4.4 to 4.6? (postgres trouble) |