"Carlo Stonebanks" <stonec.register@xxxxxxxxxxxx> 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance