Received: from megazone.bigpanda.com (megazone.bigpanda.com [63.150.15.178]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fBE6lQm35932 for ; Fri, 14 Dec 2001 01:47:30 -0500 (EST) (envelope-from sszabo@megazone23.bigpanda.com) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id 89E4DD5F4; Thu, 13 Dec 2001 22:47:26 -0800 (PST) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id 7D9245BF0; Thu, 13 Dec 2001 22:47:26 -0800 (PST) Date: Thu, 13 Dec 2001 22:47:26 -0800 (PST) From: Stephan Szabo To: MindTerm Cc: Subject: Re: performance tuning in large function / transaction In-Reply-To: <20011214033428.93468.qmail@web20203.mail.yahoo.com> Message-ID: <20011213224623.E8240-100000@megazone23.bigpanda.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200112/138 X-Sequence-Number: 5961 On Thu, 13 Dec 2001, MindTerm wrote: > Hi all, > > I will try to assign more memory to shared memory, > say 50M ~ 100M . Forgot to mention. This depends on how much memory you've actually got in the machine, but keep a bunch for backend local memory stuff and system disk caching too. Going too high on shared memory can also be bad.