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