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 fBDGRPm63295 for ; Thu, 13 Dec 2001 11:27:25 -0500 (EST) (envelope-from mindterm@yahoo.com) Message-ID: <20011213162729.98316.qmail@web20210.mail.yahoo.com> Received: from [137.189.4.4] by web20210.mail.yahoo.com via HTTP; Thu, 13 Dec 2001 08:27:29 PST Date: Thu, 13 Dec 2001 08:27:29 -0800 (PST) From: MindTerm Subject: performance tuning in large function / transaction To: pgsql-sql@postgresql.org In-Reply-To: <002d01c1837e$710f7180$0100a8c0@sjc.mindspring.net> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Archive-Number: 200112/129 X-Sequence-Number: 5952 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