"Bendik R. Johansen" <bendik(dot)johansen(at)gmail(dot)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