pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Martin Fandel <martin.fandel@alphyra-evs.de>
To: Steinar H. Gunderson <sgunderson@bigfoot.com>
Cc: Postgresql Performance list <pgsql-performance@postgresql.org>
Subject: Re: postgresql-8.0.1 performance tuning
Date: Thu, 2 Jun 2005 14:50:00 +0200
Message-ID: <1117716600.4380.13.camel@fandelm.ecommit.de> (raw)
In-Reply-To: <20050601095754.GA24585@uio.no>
References: <1117201312.7060.6.camel@fandelm.ecommit.de>

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 */




view thread (13+ messages)  latest in thread

Message-ID: <1117716600.4380.13.camel@fandelm.ecommit.de>
Permalink:  ../1117716600.4380.13.camel@fandelm.ecommit.de/
Also on:    postgresql.org/message-id/1117716600.4380.13.camel@fandelm.ecommit.de

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: martin.fandel@alphyra-evs.de, sgunderson@bigfoot.com
  Subject: Re: postgresql-8.0.1 performance tuning
  In-Reply-To: <1117716600.4380.13.camel@fandelm.ecommit.de>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox