Received: from megazone.bigpanda.com (megazone.bigpanda.com [63.150.15.178]) by postgresql.org (Postfix) with ESMTP id 345F2474E71 for ; Sat, 13 Apr 2002 10:57:05 -0400 (EDT) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id C9C71D5FA; Sat, 13 Apr 2002 07:57:08 -0700 (PDT) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id BF7975C01; Sat, 13 Apr 2002 07:57:08 -0700 (PDT) Date: Sat, 13 Apr 2002 07:57:08 -0700 (PDT) From: Stephan Szabo To: Rajesh Kumar Mallah Cc: PostgResql SQL Mailing List Subject: Re: deletions on master table takes for ever... In-Reply-To: <3CB8037E.B73F7F6D@trade-india.com> Message-ID: <20020413075506.W84263-100000@megazone23.bigpanda.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200204/168 X-Sequence-Number: 7432 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.