Horton

Re: Comparitive UPDATE speed

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Josh Berkus <josh@agliodbs.com>
Cc: Andrew Sullivan <andrew@libertyrms.info>, pgsql-performance@postgresql.org
Date: 2002-10-04T19:45:28Z
Lists: pgsql-performance 
Josh Berkus <josh@agliodbs.com> writes:
> When the UPDATE query takes a long time, I generally can watch the log hover 
> in the land of "Reaping dead child processes" for 30-90 seconds per 
> iteration.

Uh ... would you translate that observation into English please?  Or
better, provide the log output you're looking at?

			regards, tom lane