Re: [BUGS] BUG #1398: Delete takes a long time & explain disagrees with \timing

2005-01-14 Thread Tom Lane
"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

[BUGS] BUG #1398: Delete takes a long time & explain disagrees with \timing

2005-01-13 Thread Karl Martindale
The following bug has been logged online: Bug reference: 1398 Logged by: Karl Martindale Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4.6 Operating system: Slackware 9.0 - Linux version 2.4.26 ([EMAIL PROTECTED]) (gcc version 3.3.4) Description:Delete takes