performance tuning in large function / transaction - Mailing list pgsql-sql

From MindTerm
Subject performance tuning in large function / transaction
Date
Msg-id 20011213162729.98316.qmail@web20210.mail.yahoo.com
Whole thread Raw
In response to cidr question (resent)  ("Mir S Islam" <mislam@mindspring.com>)
Responses Re: performance tuning in large function / transaction
Re: performance tuning in large function / transaction
Re: performance tuning in large function / transaction
List 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


pgsql-sql by date:

Previous
From: S P Arif Sahari Wibowo
Date:
Subject: Varying bit field: to set and query a particular bit
Next
From: Jason Earl
Date:
Subject: Re: performance tuning in large function / transaction