Re: postgresql-8.0.1 performance tuning

От: Mark Kirkwood
Тема: Re: postgresql-8.0.1 performance tuning
Дата: ,
Msg-id: 429D56B2.9070302@paradise.net.nz
(см: обсуждение, исходный текст)
Ответ на: Re: postgresql-8.0.1 performance tuning  (Cosimo Streppone)
Ответы: Re: postgresql-8.0.1 performance tuning  (Cosimo Streppone)
SHMMAX / SHMALL Was (Re: postgresql-8.0.1 performance tuning)  (Paul McGarry)
Список: pgsql-performance

Скрыть дерево обсуждения

postgresql-8.0.1 performance tuning  ("Martin Fandel", )
 Re: postgresql-8.0.1 performance tuning  (John A Meinel, )
  Re: postgresql-8.0.1 performance tuning  ("Martin Fandel", )
 Re: postgresql-8.0.1 performance tuning  (Cosimo Streppone, )
  Re: postgresql-8.0.1 performance tuning  (Mark Kirkwood, )
   Re: postgresql-8.0.1 performance tuning  (Cosimo Streppone, )
    Re: postgresql-8.0.1 performance tuning  (Mark Kirkwood, )
   SHMMAX / SHMALL Was (Re: postgresql-8.0.1 performance tuning)  (Paul McGarry, )
    Re: SHMMAX / SHMALL Was (Re: postgresql-8.0.1 performance  (Mark Kirkwood, )
     Re: SHMMAX / SHMALL Was (Re: postgresql-8.0.1 performance tuning)  ("Martin Fandel", )
      Re: SHMMAX / SHMALL Was (Re: postgresql-8.0.1 performance  (Mark Kirkwood, )
       Re: SHMMAX / SHMALL Was (Re: postgresql-8.0.1 performance tuning)  ("Martin Fandel", )
  Re: postgresql-8.0.1 performance tuning  ("Steinar H. Gunderson", )
   Re: postgresql-8.0.1 performance tuning  (Cosimo Streppone, )
   Re: postgresql-8.0.1 performance tuning  ("Martin Fandel", )
   Re: postgresql-8.0.1 performance tuning  ("Martin Fandel", )
    Re: postgresql-8.0.1 performance tuning  ("Martin Fandel", )
     Re: postgresql-8.0.1 performance tuning  ("Martin Fandel", )

Cosimo Streppone wrote:
> ######### Config ############
>> /etc/sysctl.conf:
>> kernel.shmall = 786432000
>> kernel.shmmax = 786432000
>
>
> I think you have a problem here.
> kernel.shmmax should *not* be set to an amount of RAM, but
> to maximum number of shared memory pages, which on a typical linux system
> is 4kb. Google around:
>
>
>

This is somewhat confusing :

kernel.shmmax is in bytes (max single segment size)
kernel.shmall is in (4k) pages (max system wide allocated segment pages)

cheers

Mark




В списке pgsql-performance по дате сообщения:

От: "Martin Fandel"
Дата:
Сообщение: Re: postgresql-8.0.1 performance tuning
От: Alvaro Herrera
Дата:
Сообщение: Re: TIP 9: the planner will ignore... & datatypes