Re: postgresql-8.0.1 performance tuning

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

I've forgotten the settings for the pgbench-tests. I use 150 clients
with 5 transactions each.


Am Donnerstag, den 02.06.2005, 15:10 +0200 schrieb Martin Fandel:
> Ups,
> i'm sorry. i've set the following values:
>
> postgresql.conf:
> shared_buffers                  = 70000
> effective_cache_size            = 1744762
> work_mem                        = 32768
> maintenance_work_mem            = 262144
> max_fsm_pages                   = 200000
>
> sysctl.conf:
> vm.swappiness=10
> kernel.shmmax=715827882
> kernel.shmall=2097152
>
> Are the values ok for a 2 GB machine? I'm testing these settings
> with contrib/pgbench. With this configuration i become up to 200tps
> including connection establishing. Is that value ok for this hardware?:
>
> 1xP4 3Ghz (hyperthreading enabled)
> 2GB 266 Mhz RAM CL2.5
>
> pg_xlog is on sda (raid1 with two 10k discs) and the database on
> sdb(raid10 with four 10k discs).
>
> My Linux distribution is Suse Linux 9.3 with postgresql 8.0.1.
>
> best regards,
> Martin
>
> Am Donnerstag, den 02.06.2005, 14:50 +0200 schrieb 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 */
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 6: Have you searched our list archives?
> >
> >                http://archives.postgresql.org
>



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

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