Received: from megazone.bigpanda.com (megazone.bigpanda.com [63.150.15.178]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fBE321m24508 for ; Thu, 13 Dec 2001 22:02:01 -0500 (EST) (envelope-from sszabo@megazone23.bigpanda.com) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id 7FD43D5F4; Thu, 13 Dec 2001 19:02:05 -0800 (PST) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id 7594E5BF0; Thu, 13 Dec 2001 19:02:05 -0800 (PST) Date: Thu, 13 Dec 2001 19:02:05 -0800 (PST) From: Stephan Szabo To: MindTerm Cc: Subject: Re: performance tuning in large function / transaction In-Reply-To: <20011214024652.79128.qmail@web20210.mail.yahoo.com> Message-ID: <20011213185555.D6476-100000@megazone23.bigpanda.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200112/134 X-Sequence-Number: 5957 On Thu, 13 Dec 2001, MindTerm wrote: > I am writing a function (plpgsql) which equals to a > single transaction transaction in postgresql ( as I > known ). So I think that it is not a autocommmit mode. > > I have add following lines in postgresql.conf. > > postgresql.conf: > ==================== > shared_buffers = 640 > wal_buffers = 80 It depends on how much memory you have, but even 640 is pretty low (I think that works out to 5M). Probably a few thousand is better if you've got the ram.