Re: out of memory woes

From: "Angva" <angvaw(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: out of memory woes
Date: 2006-12-19 21:28:16
Message-ID: 1166563696.532099.250200@80g2000cwy.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

We found that the kernel setting SHMALL was set ridiculously high -
1024g!. Someone noticed this when running "ipcs -lm" - seemed just a
tad off. :)

------ Shared Memory Limits --------
max number of segments = 4096
max seg size (kbytes) = 524288
max total shared memory (kbytes) = 1073741824
min seg size (bytes) = 1

Now it is set to ceil(SHMMAX/PAGE_SIZE) as recommended in the Postgres
documentation. Testing the heck out of the parallel clusters now...

Mark

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Walter Vaughan 2006-12-19 21:31:12 admin82.sql
Previous Message Glen Parker 2006-12-19 21:19:39 Re: Autovacuum Improvements