Postgres Pro
Downloads
Home   >   mailing lists

Re: Comparitive UPDATE speed - Mailing list pgsql-performance

From Tom Lane
Subject Re: Comparitive UPDATE speed
Date
Msg-id 26159.1033760728@sss.pgh.pa.us
Whole thread Raw
In response to Re: Comparitive UPDATE speed  (Josh Berkus <josh@agliodbs.com>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Comparitive UPDATE speed
Next
From: Josh Berkus
Date:
Subject: Re: Comparitive UPDATE speed