Re: [ADMIN] shared_buffers and shmmax - Mailing list pgsql-docs

From Tom Lane
Subject Re: [ADMIN] shared_buffers and shmmax
Date
Msg-id 28167.1216737959@sss.pgh.pa.us
Whole thread Raw
Responses Re: [ADMIN] shared_buffers and shmmax  ("Francisco Reyes" <lists@stringsutils.com>)
Re: [ADMIN] shared_buffers and shmmax  ("Greg Sabino Mullane" <greg@turnstep.com>)
Re: [ADMIN] shared_buffers and shmmax  (Bruce Momjian <bruce@momjian.us>)
List pgsql-docs
[ redirecting to pgsql-docs ]

Valentin Bogdanov <valiouk@yahoo.co.uk> writes:
>> From: dx k9 <bitsandbytes88@hotmail.com>
>> I'm trying to understand what the documentation means
>> by bytes per increment, what is the increment supposed to
>> be bytes, MB, or Kb.

> shared_buffers is in disk block size, typically 8K, at least that's what it is on Linux platforms. shmmax is quite
simplyin bytes. 

The table the OP is looking at (table 17.2 in the 8.3 docs) predates
the ability to specify shared_buffers in KB or MB instead of
number-of-buffers.  I agree it's not entirely obvious that what it
means is "multiply your setting in KB/MB by 8400/8192".  Anybody have
an idea how to clarify things?

            regards, tom lane

pgsql-docs by date:

Previous
From: Tom Lane
Date:
Subject: Re: triggers on views?
Next
From: "Francisco Reyes"
Date:
Subject: Re: [ADMIN] shared_buffers and shmmax