On Friday 04 July 2008, tv(at)fuzzy(dot)cz wrote:
> > My next question is: what is the difference between "select" and
> > "delete"? There is another table that has one foreign key to reference
> > the test (parent) table that I am deleting from and this foreign key
> > does not have an index on it (a 330K row table).
>
Yeah you need to fix that. You're doing 80,000 sequential scans of that
table to do your delete. That's a whole lot of memory access ...
I don't let people here create foreign key relationships without matching
indexes - they always cause problems otherwise.
--
Alan