X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id CAC0A32AF4A for ; Wed, 20 Oct 2004 05:02:39 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 73174-08 for ; Wed, 20 Oct 2004 04:02:34 +0000 (GMT) Received: from mproxy.gmail.com (rproxy.gmail.com [64.233.170.194]) by svr1.postgresql.org (Postfix) with ESMTP id 42E6332AF0C for ; Wed, 20 Oct 2004 05:02:31 +0100 (BST) Received: by mproxy.gmail.com with SMTP id 73so425702rnk for ; Tue, 19 Oct 2004 21:02:30 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:references; b=cBu7ohHjSXpGh5QXF7aMIn9pFQEOXe1q5wR7VskXABmRTrgV80luQs2r3svAcDxSTZqdgKn4VbeHcx/7h2MV1pMiu7rww2i1MviEtJLceXE3iJkHwkEiBDof3h6ghiv1Ve9ybl7zNMOOiZPoRbOxe8KrPQFXP8bZkC3t1eTgP68 Received: by 10.38.181.77 with SMTP id d77mr2339362rnf; Tue, 19 Oct 2004 21:02:30 -0700 (PDT) Received: by 10.38.76.42 with HTTP; Tue, 19 Oct 2004 21:02:30 -0700 (PDT) Message-ID: <4a0cafe2041019210265656d4e@mail.gmail.com> Date: Tue, 19 Oct 2004 23:02:30 -0500 From: Josh Close Reply-To: Josh Close To: POSTGRES-PERFORMANCE Subject: Re: how much mem to give postgres? In-Reply-To: <01f301c4b63c$643340b0$6400a8c0@Nightingale> Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit References: <4a0cafe2041019153133f854e9@mail.gmail.com> <01f301c4b63c$643340b0$6400a8c0@Nightingale> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200410/305 X-Sequence-Number: 8781 On Wed, 20 Oct 2004 01:33:16 +0100, Simon Riggs wrote: > ....and using what version of PostgreSQL are you using? 8.0beta, I hope? I'm using version 7.4.5. > > I was thinking I need to increase the amount of shared buffers, but > > I've been told "the sweet spot for shared_buffers is usually on the > > order of 10000 buffers". I already have it set at 21,078. If you have, > > say 100 gigs of ram, are you supposed to still only give postgres > > 10,000? > > Thats under test currently. My answer would be, "clearly not", others > differ, for varying reasons. Should I stick the rule of around 15% of mem then? I haven't found any information on why you should use certain settings at all. I read somewhere on the postgres site about using as much memory as possible, but leave a little room for other processes. Whould that be an ok theory? I'd kinda like to know why I should or shouldn't do something like this. -Josh