Re: shared_buffers revisited

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Thalis A(dot) Kalfigopoulos" <thalis(at)cs(dot)pitt(dot)edu>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: shared_buffers revisited
Date: 2001-07-20 22:23:26
Message-ID: 5453.995667806@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Thalis A. Kalfigopoulos" <thalis(at)cs(dot)pitt(dot)edu> writes:
> Another minor issue that has come to my attention is that when I define
> shared_buffers=40000
> I assume that it'll need a shm segment of 40000*8192=327680000 bytes
> And so I set /proc/sys/kernel/shmall and shmmax accordingly only to find out that postmaster failes to start because it requests a shmsegment of 336404480 bytes. Where is the fallacy in my math?

Shared buffers are not the only things we keep in shared memory ...

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tim Barnard 2001-07-20 22:30:38 Re: Language C - Console-based FrontEnd
Previous Message Lamar Owen 2001-07-20 22:16:58 Re: RPM source files should be in CVS (was Re: [GENERAL] psql -l)