Postgres Pro
Downloads
Home   >   mailing lists

Re: Massive table (500M rows) update nightmare - Mailing list pgsql-performance

From Kevin Grittner
Subject Re: Massive table (500M rows) update nightmare
Date
Msg-id 4B462563020000250002DFA3@gw.wicourts.gov
Whole thread Raw
In response to Re: Massive table (500M rows) update nightmare  ("Carlo Stonebanks" <stonec.register@sympatico.ca>)
Responses Re: Massive table (500M rows) update nightmare
List pgsql-performance
Tree view 
"Carlo Stonebanks" <stonec.register@sympatico.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

pgsql-performance by date:

Previous
From: hubert depesz lubaczewski
Date:
Subject: Re: Air-traffic benchmark
Next
From: Greg Smith
Date:
Subject: Re: Air-traffic benchmark