"Karl Martindale" <karl(at)cyber(dot)com(dot)au> writes:
> Deletes from this particular table take a long time (~5 min for 6000rows)
This usually occurs when you have another table with a foreign key
reference to this one, and the referencing column either has no index or
isn't of the exact same datatype as the referenced column. The FK
checks then are forced to use sequential scans instead of index probes
:-(
regards, tom lane