Re: Bad performance in bulky updates

From: Richard Broersma Jr <rabroersma(at)yahoo(dot)com>
To: carlos(dot)reimer(at)opendb(dot)com(dot)br, "Pgsql-General(at)Postgresql(dot)Org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Bad performance in bulky updates
Date: 2006-10-31 03:38:48
Message-ID: 20061031033848.19246.qmail@web31814.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> Is there any other suggestion to improve the performance of those updates?

Perhaps turning on query duration logging so see if any particular queries are giving you grief.

Other than that I would repost this email on the preformance list as you will get better responses
from that list. :o)

Regards,

Richard Broersma Jr.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ron Peterson 2006-10-31 03:49:33 PostgreSQL Mhash functions
Previous Message Michael Fuhr 2006-10-31 03:37:42 Re: creating a dumpfile from a view