Re: Foreign Key ON DELETE CASCADE Performance

Bruno, you're a genius! :)

I /had/ missed adding a single index. It made all the difference in the world.

Boy! That's a relief.

CG

--- Bruno Wolff III <bruno(at)wolff(dot)to> wrote:
> On Fri, Apr 30, 2004 at 09:35:39 -0700,
> Chris Gamache <cgg007(at)yahoo(dot)com> wrote:
> >
> > What can be done to increase the overall speed of this transaction, keeping
> the
> > FKey Constraints in-place?
>
> The fastest thing to do if you really want to get rid of everything is
> do delete from for each of the tables starting with the ones that don't
> have any tables dependent on them.
>
> Another thing to note is that postgres doesn't automatically create
> an index on columns that reference another table. When you are taking
> advantage of cascading deletes you normally will want an index on such
> columns. If you insist upon being able to do the delete using just a delete
> from table1 you will want to create these indexes.

__________________________________
Do you Yahoo!?
Win a $20,000 Career Makeover at Yahoo! HotJobs
http://hotjobs.sweepstakes.yahoo.com/careermakeover