Re: [ADMIN] shared_buffers and shmmax
От
Bruce Momjian
Тема
Re: [ADMIN] shared_buffers and shmmax
Дата
Msg-id
200812152323.mBFNN3Y25121@momjian.us
Ответ на
Re: [ADMIN] shared_buffers and shmmax (Tom Lane)
Список
Дерево обсуждения
Re: [ADMIN] shared_buffers and shmmax Tom Lane <tgl@sss.pgh.pa.us>
Re: [ADMIN] shared_buffers and shmmax Bruce Momjian <bruce@momjian.us>
Re: [ADMIN] shared_buffers and shmmax Alvaro Herrera <alvherre@commandprompt.com>
Re: [ADMIN] shared_buffers and shmmax Alvaro Herrera <alvherre@commandprompt.com>
Re: [ADMIN] shared_buffers and shmmax Bruce Momjian <bruce@momjian.us>
Re: [ADMIN] shared_buffers and shmmax Tom Lane <tgl@sss.pgh.pa.us>
Re: [ADMIN] shared_buffers and shmmax Bruce Momjian <bruce@momjian.us>
Re: [ADMIN] shared_buffers and shmmax Tom Lane <tgl@sss.pgh.pa.us>
Re: [ADMIN] shared_buffers and shmmax Bruce Momjian <bruce@momjian.us>
Re: [ADMIN] shared_buffers and shmmax Tom Lane <tgl@sss.pgh.pa.us>
Re: [ADMIN] shared_buffers and shmmax Bruce Momjian <bruce@momjian.us>
Re: [ADMIN] shared_buffers and shmmax Alvaro Herrera <alvherre@commandprompt.com>
Re: [ADMIN] shared_buffers and shmmax Bruce Momjian <bruce@momjian.us>
Re: [ADMIN] shared_buffers and shmmax Alvaro Herrera <alvherre@commandprompt.com>
Tom Lane wrote:
> [ redirecting to pgsql-docs ]
>
> Valentin Bogdanov writes:
> >> From: dx k9
> >> 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 simply in 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?
I have updated the table title to be clearer.
--
Bruce Momjian http://momjian.us
EnterpriseDB http://enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
Index: doc/src/sgml/runtime.sgml
===================================================================
RCS file: /cvsroot/pgsql/doc/src/sgml/runtime.sgml,v
retrieving revision 1.422
diff -c -c -r1.422 runtime.sgml
*** doc/src/sgml/runtime.sgml 20 Nov 2008 11:48:26 -0000 1.422
--- doc/src/sgml/runtime.sgml 15 Dec 2008 23:22:24 -0000
***************
*** 1087,1093 ****
Name</>
! Approximate multiplier (bytes per increment) as of 8.3</>
--- 1087,1093 ----
Name</>
! Additional bytes per object, as of 8.3</>
***************
*** 1119,1125 ****
Fixed space requirements</>
! 770 kB
--- 1119,1125 ----
Fixed space requirements</>
! 770 k
В списке pgsql-docs по дате отправления