Re: Slow update - Mailing list pgsql-performance

From Tom Lane
Subject Re: Slow update
Date
Msg-id 21383.1113320438@sss.pgh.pa.us
Whole thread Raw
In response to Re: Slow update  (Bendik R.Johansen <bendik.johansen@gmail.com>)
List pgsql-performance
"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

pgsql-performance by date:

Previous
From: Bendik R.Johansen
Date:
Subject: Re: Slow update
Next
From: "Matthew Nuzum"
Date:
Subject: performance hit for replication