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 <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 по дате отправления
От: Magnus Hagander
Дата:
От: Bruce Momjian
Дата:
FAQ