Re: deletions on master table takes for ever...

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Rajesh Kumar Mallah <mallah(at)trade-india(dot)com>
Cc: PostgResql SQL Mailing List <pgsql-sql(at)postgresql(dot)org>
Subject: Re: deletions on master table takes for ever...
Date: 2002-04-13 14:57:08
Message-ID: 20020413075506.W84263-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message postgresql 2002-04-13 16:57:25 to_char problem
Previous Message Rajesh Kumar Mallah 2002-04-13 10:07:58 deletions on master table takes for ever...