"Karl Martindale" <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
