Re: Massive table (500M rows) update nightmare

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: <pgsql-performance(at)postgresql(dot)org>, "Carlo Stonebanks" <stonec(dot)register(at)sympatico(dot)ca>
Subject: Re: Massive table (500M rows) update nightmare
Date: 2010-01-08 00:18:11
Message-ID: 4B462563020000250002DFA3@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"Carlo Stonebanks" <stonec(dot)register(at)sympatico(dot)ca> wrote:

> An interesting idea, if I can confirm that the performance problem
> is because of the WHERE clause, not the UPDATE.

If you could show EXPLAIN ANALYZE output for one iteration, with
related queries and maybe more info on the environment, it would
take most of the guesswork out of things.

-Kevin

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Greg Smith 2010-01-08 00:38:34 Re: Air-traffic benchmark
Previous Message hubert depesz lubaczewski 2010-01-07 23:39:33 Re: Air-traffic benchmark