Re: shared_buffers/SHMMAX defaults?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Martin Pitt <mpitt(at)debian(dot)org>
Cc: PostgreSQL Bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: shared_buffers/SHMMAX defaults?
Date: 2009-04-01 13:39:01
Message-ID: 3952.1238593141@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Martin Pitt <mpitt(at)debian(dot)org> writes:
> Tom Lane [2009-03-30 20:29 -0400]:
>> Consider
>> (4) Lobby your kernel packagers to install saner SHMMAX/SHMALL
>> defaults.

> Sounds good. :-)

> Those are the current defaults:

> kernel.shmmax = 33554432
> kernel.shmall = 2097152
> kernel.shmmni = 4096

Hm, those shmall and shmmni values seem large enough to not pose a
problem. I think you need to look into the failure reports a little
more closely to figure out what's really wrong.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Bruce Toll 2009-04-01 18:55:42 BUG #4747: Some type names accepted in place of column name.
Previous Message Alvaro Herrera 2009-04-01 12:04:44 Re: BUG #4744: Windows 2008: FATAL: could not reattach to shared memory: 487