Re: atrocious update performance - Mailing list pgsql-performance

From Rosser Schwarz
Subject Re: atrocious update performance
Date
Msg-id 003c01c410f1$0192d7e0$2500fa0a@CardServices.TCI.com
Whole thread Raw
In response to Re: atrocious update performance  (Greg Spiegelberg <gspiegelberg@cranel.com>)
Responses Re: atrocious update performance
List pgsql-performance
Greg Spiegelberg wrote:

> I've been following this thread closely as I have the same problem
> with an UPDATE.  Everything is identical here right down to the
> strace output.

> Has anyone found a workaround or resolved the problem?  If not,
> I have test systems here which I can use to help up test and explore.

I'm still gathering data.  The explain analyze I'd expected to finish
Thursday afternoon hasn't yet.  I'm going to kill it and try a few
smaller runs, increasing in size, until the behavior manifests.

Will advise.

/rls


pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Optimisation of INTERSECT expressions
Next
From: "Phil Endecott"
Date:
Subject: Re: Optimisation of INTERSECT expressions