performance tuning in large function / transaction
MindTerm <mindterm@yahoo.com>
From: MindTerm <mindterm@yahoo.com>
To: pgsql-sql@postgresql.org
Date: 2001-12-13T16:27:29Z
Lists: pgsql-sql
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