Re: postgresql-8.0.1 performance tuning

От: Martin Fandel
Тема: Re: postgresql-8.0.1 performance tuning
Дата: ,
Msg-id: 1117716600.4380.13.camel@fandelm.ecommit.de
(см: обсуждение, исходный текст)
Ответ на: Re: postgresql-8.0.1 performance tuning  ("Steinar H. Gunderson")
Ответы: Re: postgresql-8.0.1 performance tuning  ("Martin Fandel")
Список: 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", )

Hi,

hmmm i don't understand which are the best values for shmmax and shmall.
I've googled around but every site says something different.

I've 2GB of RAM now and set it to:

kernel.shmmax=715827882
kernel.shmall=2097152

Is that value ok for 2GB of RAM?

I've set the shared_buffers in my postgresql.conf to 87381
(87381*8*1024 = ~715827882).

Can I use www.powerpostgresql.com as reference to set this
parameters? Or which site can i use?

Best regards,
Martin

Am Mittwoch, den 01.06.2005, 11:57 +0200 schrieb Steinar H. Gunderson:
> On Wed, Jun 01, 2005 at 07:30:37AM +0200, Cosimo Streppone wrote:
> >>fsync                           = true
> > false
>
> Just setting fsync=false without considering the implications is a
_bad_
> idea...
>
> /* Steinar */


Am Mittwoch, den 01.06.2005, 11:57 +0200 schrieb Steinar H. Gunderson:
> On Wed, Jun 01, 2005 at 07:30:37AM +0200, Cosimo Streppone wrote:
> >>fsync                           = true
> > false
>
> Just setting fsync=false without considering the implications is a _bad_
> idea...
>
> /* Steinar */



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

От: Vivek Khera
Дата:
Сообщение: Re: Adaptec/LSI/?? RAID
От: PFC
Дата:
Сообщение: Re: Query plan for very large number of joins