On 10/29/07, Campbell, Lance <lance@xxxxxxxx> wrote:
> Thanks for all of your help. The problem was that the result_entry table
> had some constraints that pointed to a third table. When I removed
> those constraints the performance was amazing. The update took less
> than seven minutes to execute. I did not even consider the fact that
> constraints to another table would impact the performance.
Usually you can put an index on the refrerenced key in the foreign
table to speed things up.
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
