Re: atrocious update performance

From: "Rosser Schwarz" <rschwarz(at)totalcardinc(dot)com>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: atrocious update performance
Date: 2004-03-23 16:07:57
Message-ID: 003c01c410f1$0192d7e0$2500fa0a@CardServices.TCI.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Josh Berkus 2004-03-23 16:15:39 Re: [PERFORM] Benchmarking postgres on Solaris/Linux
Previous Message Tom Lane 2004-03-23 15:47:42 Re: Optimisation of INTERSECT expressions