Received: from charon.simplot.com (jrsmailhub.simplot.com [12.18.144.212]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fBDIudm72095 for ; Thu, 13 Dec 2001 13:56:39 -0500 (EST) (envelope-from earlj@xanadu.simplot.com) Received: from xanadu.simplot.COM (151.113.0.132) by charon.simplot.com (MX V5.1-A AnGp) with SMTP; Thu, 13 Dec 2001 11:56:37 -0700 Received: from npa01zz001.simplot.com by xanadu.simplot.COM; (5.65v4.0/1.1.8.2/20Aug97-1116AM) id AA29342; Thu, 13 Dec 2001 11:56:37 -0700 Received: from earlj by npa01zz001.simplot.com with local (Exim 3.33 #1 (Debian)) id 16Eb23-000865-00; Thu, 13 Dec 2001 11:56:35 -0700 To: MindTerm CC: pgsql-sql@postgresql.org Subject: Re: performance tuning in large function / transaction References: <20011213162729.98316.qmail@web20210.mail.yahoo.com> From: Jason Earl Date: 13 Dec 2001 11:56:35 -0700 In-Reply-To: <20011213162729.98316.qmail@web20210.mail.yahoo.com> Message-ID: <878zc7uexo.fsf@npa01zz001.simplot.com> Lines: 35 User-Agent: Gnus/5.0808 (Gnus v5.8.8) Emacs/21.1 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Archive-Number: 200112/130 X-Sequence-Number: 5953 Start here: http://candle.pha.pa.us/main/writings/pgsql/hw_performance/index.html If you have already fiddled around with these settings then share some of the queries (and their plans). Jason MindTerm writes: > 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. > > > M.T. > > __________________________________________________ > 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 > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html