Thread: Slow update
View Single Post

   
  #6 (permalink)  
Old 04-18-2008, 11:29 AM
Tom Lane
 
Posts: n/a
Default Re: Slow update

"Bendik R. Johansen" <bendik.johansen@gmail.com> writes:
> Yes, I tried dropping it but it did not make a difference.
> Could the table be corrupt or something?


You didn't directly answer the question about whether there were foreign
keys leading to this table. Checking foreign keys could be the problem,
particularly if the referencing columns don't have indexes.

Also, maybe the table is just bloated? What does VACUUM VERBOSE say
about it?

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Reply With Quote