Re: deletions on master table takes for ever... - Mailing list pgsql-sql

On Sat, 13 Apr 2002, Rajesh Kumar Mallah wrote:

> Also i would like to tell that the are 8 tables linked to the master
> table
> email_bank so every deletetion on email_bank is eight deletions.
>
> do i need to create indexes on the slave tables also ?

You probably should since otherwise it's going to need to do sequential
scans of all those tables for each row being deleted.  That may or may not
be the bottleneck here, but it's worth doing.