performance tuning in large function / transaction

From: MindTerm <mindterm(at)yahoo(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: performance tuning in large function / transaction
Date: 2001-12-13 16:27:29
Message-ID: 20011213162729.98316.qmail@web20210.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Jason Earl 2001-12-13 18:56:35 Re: performance tuning in large function / transaction
Previous Message S P Arif Sahari Wibowo 2001-12-13 15:45:28 Varying bit field: to set and query a particular bit