X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id AD265D1B450 for ; Thu, 4 Dec 2003 17:10:25 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 75122-07 for ; Thu, 4 Dec 2003 13:09:55 -0400 (AST) Received: from mail.dsvr.co.uk (mail.dsvr.co.uk [212.69.192.9]) by svr1.postgresql.org (Postfix) with ESMTP id 850D8D1B49A for ; Thu, 4 Dec 2003 13:09:54 -0400 (AST) Received: from dsvr.net (eth0.rt1.o1-1.tck.dsvr.net [::ffff:212.69.216.20]) by mail.dsvr.co.uk with esmtp; Thu, 04 Dec 2003 17:09:53 +0000 Message-ID: <3FCF6B2F.3070802@dsvr.net> Date: Thu, 04 Dec 2003 17:13:19 +0000 From: Rob Fielding User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.4) Gecko/20031119 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Re: tuning questions References: <1070553983.6498.52.camel@cletus.lyris.com> In-Reply-To: <1070553983.6498.52.camel@cletus.lyris.com> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200312/75 X-Sequence-Number: 4935 > > 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