Received: from web20210.mail.yahoo.com (web20210.mail.yahoo.com [216.136.226.65]) by postgresql.org (8.11.3/8.11.4) with SMTP id fBE2kmm23887 for ; Thu, 13 Dec 2001 21:46:49 -0500 (EST) (envelope-from mindterm@yahoo.com) Message-ID: <20011214024652.79128.qmail@web20210.mail.yahoo.com> Received: from [203.85.100.3] by web20210.mail.yahoo.com via HTTP; Thu, 13 Dec 2001 18:46:52 PST Date: Thu, 13 Dec 2001 18:46:52 -0800 (PST) From: MindTerm Subject: Re: performance tuning in large function / transaction To: Stephan Szabo Cc: pgsql-sql@postgresql.org In-Reply-To: <20011213111529.A2574-100000@megazone23.bigpanda.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Archive-Number: 200112/133 X-Sequence-Number: 5956 Hi, 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 M.T. --- Stephan Szabo wrote: > On Thu, 13 Dec 2001, MindTerm wrote: > > > Hi all, > > > > I am writing a large function which perform more > > than 2000 modify statements ( delete / insert ) . > The > > execution time of this function is not acceptable. > How > > can I config postgresql ( in postgresql.conf ?? ) > so > > that the performance will be better ? The machine > > runing postgresql have spare memory and harddisk > > space. > > It's hard without more information, is the function > like > an internal function or do you mean an external one? > In the latter case, the first thing to do is make > sure you're not in autocommit (ie, you've begun a > transaction) since otherwise you're doing 2000 > separate transactions. > The settings that are the first to look at in the > postgresql.conf are shared_buffers and sort_mem. > > > ---------------------------(end of > broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html __________________________________________________ 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