Received: from makus.postgresql.org ([98.129.198.125])
	by malur.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <vibhor.aim@gmail.com>) id 1TGG6b-0001Dy-1t
	for pgsql-admin@postgresql.org; Mon, 24 Sep 2012 21:22:17 +0000
Received: from mail-gg0-f174.google.com ([209.85.161.174])
	by makus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <vibhor.aim@gmail.com>) id 1TGG6Z-0001mt-Gq
	for pgsql-admin@postgresql.org; Mon, 24 Sep 2012 21:22:16 +0000
Received: by ggnr5 with SMTP id r5so1284259ggn.19
	for <pgsql-admin@postgresql.org>; Mon, 24 Sep 2012 14:22:14 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113;
	h=content-type:mime-version:subject:from:in-reply-to:date:cc
	:content-transfer-encoding:message-id:references:to:x-mailer;
	bh=G8qq5rYAWfLpmbOZUwuNhqaoQpittpAs2GdJAyMRLLM=;
	b=Tozh+kZqqRvw7ExQ6s2RLxlubD88+BGMBBn7farwTFpSM3L5t4MdH1ycqT5w1XqvaI
	u3NNrPJOUm3PeUfRVDaFTlrKRucusnaQI9zj0zSygV2bGhFTuKVUMwZhL84bRLBNwi7t
	smo+GoA2kKsHsDTt5VS+XusHo5evsdXQrzpHoUTMCMv6cgH/9GLT+dXgnvHiVz34pCQF
	6h4WZIdM+EYb8Z4rUWAXgmIyn4oQSDEn2QTpZeSHKF6E/gq5bu+GuB35T+wExSEK4NaY
	RX3/Bm3mzBpckj/XZv3ZQK7jFY9NA+d4oNosvPeLB1Od2CrO2YLe4B7MKzPJbVgrt+Gt
	XikQ==
Received: by 10.236.154.165 with SMTP id h25mr13751043yhk.38.1348521734292;
	Mon, 24 Sep 2012 14:22:14 -0700 (PDT)
Received: from [172.24.38.120]
	(70-91-216-177-BusName-NewEngland.hfc.comcastbusiness.net.
	[70.91.216.177])
	by mx.google.com with ESMTPS id h22sm6031663yhk.13.2012.09.24.14.22.12
	(version=SSLv3 cipher=OTHER); Mon, 24 Sep 2012 14:22:13 -0700 (PDT)
Content-Type: text/plain; charset=iso-8859-1
Mime-Version: 1.0 (Mac OS X Mail 6.1 \(1498\))
Subject: Re: dropping a large table is taking a very long time (about 2 hours
	so far)
From: Vibhor Kumar <vibhor.aim@gmail.com>
In-Reply-To: 
 <CAOHVLOFBYojG-6tSMB3PM2a2CSO3B434svFGDudLdg5rVCMVLg@mail.gmail.com>
Date: Mon, 24 Sep 2012 17:33:52 -0400
Cc: pgsql-admin@postgresql.org
Content-Transfer-Encoding: quoted-printable
Message-Id: <B0703573-E6A2-458D-96D1-FB2E2EE905E1@gmail.com>
References: 
 <CAOHVLOFBYojG-6tSMB3PM2a2CSO3B434svFGDudLdg5rVCMVLg@mail.gmail.com>
To: Evan Walter <ewalter@decisionanalyst.com>
X-Mailer: Apple Mail (2.1498)
X-Pg-Spam-Score: -2.6 (--)
X-Archive-Number: 201209/142
X-Sequence-Number: 40083


On Sep 24, 2012, at 5:10 PM, Evan Walter <ewalter@decisionanalyst.com> =
wrote:

> There were probaby about 5 million records in the table.  I do not =
believe
> there were any foreign keys to the table  The drop table has been =
going for
> over 2 hours.  Is that normal?


Not to me. I would have checked if DROP command is in waiting state. =
Also looked at pg_locks for more information on locks.

Thanks & Regards,
Vibhor Kumar
Blogs:http://vibhork.blogspot.com
http://vibhorkumar.wordpress.com