pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Iain <iain@mst.co.jp>
To: postuser@spr.og.th
Cc: pgsql-performance@postgresql.org
Subject: Re: Howto Increased performace ?
Date: Mon, 27 Dec 2004 18:34:45 +0900
Message-ID: <003a01c4ebf7$503de6a0$7201a8c0@mst1x5r347kymb> (raw)
References: <2452.192.168.2.6.1103621509.squirrel@192.168.2.6>
	<00cb01c4ebb3$94aebf10$7201a8c0@mst1x5r347kymb>
	<45410.192.168.2.17.1104139293.squirrel@192.168.2.17>

Hi,

These are some settings that I am planning to start with for a 4GB RAM dual 
opteron system with a maximum of 100 connections:


shared_buffers 8192 (=67MB RAM)
sort_mem 4096 (=400MB RAM for 100 connections)
effective_cache_size 380000(@8KB  =3.04GB RAM)
vacuum_mem 32768 KB
wal_buffers 64
checkpoint_segments 8

In theory, effective cache size is the amount of memory left over for the OS 
to cache the filesystem after running all programs and having 100 users 
connected, plus a little slack.

regards
Iain
----- Original Message ----- 
From: "Amrit Angsusingh" <postuser@spr.og.th>
To: "Iain" <iain@mst.co.jp>
Cc: <pgsql-performance@postgresql.org>
Sent: Monday, December 27, 2004 6:21 PM
Subject: Re: [PERFORM] Howto Increased performace ?


>
>
>>> #sort_mem = 1024 # min 64, size in KB
>>> sort_mem = 60000
>
>> I think this might be too much. You are using 60000KB _per connection_
>> here
>> = 10GB for your maximum of 180 connections.
>>
>> By comparison, I am specifiying 4096 (subject to adjustment) for a 
>> machine
>> with a similar spec to yours.
>>
>> regards
>> Iain
>
> I reduced it to
> sort_mem = 8192
> If I increase it higher , what will be result I could expect.
>
> and I also reduce the
> max connection to 160
> and
> shared buffer to shared_buffers = 27853
> effective_cache_size = 81920 [what does it for?]
>
> do you think is it still too much especialy effective cache ?
>
> Thanks
> Amrit
>
> Amrit Angsusingh
> Nakornsawan,Thailand 




view thread (9+ messages)  latest in thread

Message-ID: <003a01c4ebf7$503de6a0$7201a8c0@mst1x5r347kymb>
Permalink:  ../003a01c4ebf7$503de6a0$7201a8c0@mst1x5r347kymb/
Also on:    postgresql.org/message-id/003a01c4ebf7$503de6a0$7201a8c0@mst1x5r347kymb

 · 

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: iain@mst.co.jp, postuser@spr.og.th
  Subject: Re: Howto Increased performace ?
  In-Reply-To: <003a01c4ebf7$503de6a0$7201a8c0@mst1x5r347kymb>
  References: <2452.192.168.2.6.1103621509.squirrel@192.168.2.6> <00cb01c4ebb3$94aebf10$7201a8c0@mst1x5r347kymb> <45410.192.168.2.17.1104139293.squirrel@192.168.2.17> <003a01c4ebf7$503de6a0$7201a8c0@mst1x5r347kymb>

* 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