pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Rob Fielding <rob@dsvr.net>
To: pgsql-performance@postgresql.org
Subject: Re: tuning questions
Date: Thu, 04 Dec 2003 17:13:19 +0000
Message-ID: <3FCF6B2F.3070802@dsvr.net> (raw)
In-Reply-To: <1070553983.6498.52.camel@cletus.lyris.com>
References: <1070553983.6498.52.camel@cletus.lyris.com>


> 
> I've tweaked shared buffers to 8192, pushed sort memory to 2048, vacuum
> memory to 8192, and effective cache size to 10000.
> /proc/sys/kernel/shmmax is set to 1600000000 and /proc/sys/fs/file-max
> is set to 65536. Ulimit -n 3192.

Your sharedmemory is too high, and not even being used effectivey. Your 
other settings are too low.

Ball park guessing here, but I'd say first read (and understand) this:

http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html

Then make shared memory about 10-20% available ram, and set:

((shmmax/1024) - ( 14.2 * max_connections ) - 250 ) / 8.2 = shared_buffers

decrease random_page_cost to 0.3 and wack up sort mem by 16 times, 
effective cache size to about 50% RAM (depending on your other settings) 
and try that for starters.


-- 

Rob Fielding
rob@dsvr.net

www.dsvr.co.uk              Development             Designer Servers Ltd




view thread (32+ messages)  latest in thread

Message-ID: <3FCF6B2F.3070802@dsvr.net>
Permalink:  ../3FCF6B2F.3070802@dsvr.net/
Also on:    postgresql.org/message-id/3FCF6B2F.3070802@dsvr.net

 · 

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: rob@dsvr.net
  Subject: Re: tuning questions
  In-Reply-To: <3FCF6B2F.3070802@dsvr.net>

* 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