pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
To: pgsql-performance@postgresql.org
Subject: Re: slower with the time
Date: Tue, 1 Jul 2003 13:47:06 +0530
Message-ID: <200307011347.06532.shridhar_daithankar@nospam.persistent.co.in> (raw)
In-Reply-To: <3F0141E0.50703@pe-muc.de>
References: <3F013C85.2060202@pe-muc.de>
	<200307011318.00824.shridhar_daithankar@nospam.persistent.co.in>
	<3F0141E0.50703@pe-muc.de>

On Tuesday 01 July 2003 13:40, Juraj Porada wrote:
> shared_buffers = 32

That is 32*8=256KB of memory. I thought default was 64. How much physical 
memory you have?

I suggest you set it up something like 256 to start with. That may be too 
small as well but you haven't provided enough details to come up with a 
better one.

>
> I don't have much experience in tuning the database, but I think there
> is a problem with a fragmentation of memory or so.
> I don't known backgrounds.

Read postgresql.conf and admin guide about runtime parameters. You need to 
tune shared buffers and effective_cache_size at least.

Search performance archives about tuning these two. There is lot of material 
to cover in a single mail.

 HTH

 Shridhar




view thread (4+ messages)

Message-ID: <200307011347.06532.shridhar_daithankar@nospam.persistent.co.in>
Permalink:  ../200307011347.06532.shridhar_daithankar@nospam.persistent.co.in/
Also on:    postgresql.org/message-id/200307011347.06532.shridhar_daithankar@nospam.persistent.co.in

 · 

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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-performance@postgresql.org
  Cc: shridhar_daithankar@persistent.co.in
  Subject: Re: slower with the time
  In-Reply-To: <200307011347.06532.shridhar_daithankar@nospam.persistent.co.in>
  References: <3F013C85.2060202@pe-muc.de> <200307011318.00824.shridhar_daithankar@nospam.persistent.co.in> <3F0141E0.50703@pe-muc.de> <200307011347.06532.shridhar_daithankar@nospam.persistent.co.in>

* 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