Received: from web20203.mail.yahoo.com (web20203.mail.yahoo.com [216.136.226.58]) by postgresql.org (8.11.3/8.11.4) with SMTP id fBE3YOm25803 for ; Thu, 13 Dec 2001 22:34:24 -0500 (EST) (envelope-from mindterm@yahoo.com) Message-ID: <20011214033428.93468.qmail@web20203.mail.yahoo.com> Received: from [203.85.100.3] by web20203.mail.yahoo.com via HTTP; Thu, 13 Dec 2001 19:34:28 PST Date: Thu, 13 Dec 2001 19:34:28 -0800 (PST) From: MindTerm Subject: Re: performance tuning in large function / transaction To: Stephan Szabo Cc: pgsql-sql@postgresql.org In-Reply-To: <20011213185555.D6476-100000@megazone23.bigpanda.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Archive-Number: 200112/135 X-Sequence-Number: 5958 Hi all, I will try to assign more memory to shared memory, say 50M ~ 100M . I am runing something like that .. cursor loop 1 cursor loop 2 cursor loop 3 tmp = primary key delete tmp .... insert tmp .... end loop 3 end loop 2 end loop 3 will delete and insert record with same primary key within a transaction reduce the performance ? M.T. --- Stephan Szabo wrote: > 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. > __________________________________________________ Do You Yahoo!? Check out Yahoo! Shopping and Yahoo! Auctions for all of your unique holiday gifts! Buy at http://shopping.yahoo.com or bid at http://auctions.yahoo.com