Received: from makus.postgresql.org ([98.129.198.125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TGFv4-0001w7-Lq for pgsql-admin@postgresql.org; Mon, 24 Sep 2012 21:10:22 +0000 Received: from na3sys009aog122.obsmtp.com ([74.125.149.147]) by makus.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1TGFv2-0001bA-Nr for pgsql-admin@postgresql.org; Mon, 24 Sep 2012 21:10:21 +0000 Received: from mail-vb0-f46.google.com ([209.85.212.46]) (using TLSv1) by na3sys009aob122.postini.com ([74.125.148.12]) with SMTP ID DSNKUGDMOmyqm2CndGf3d4TJZhDdlIeBPMhB@postini.com; Mon, 24 Sep 2012 14:10:20 PDT Received: by vbbff1 with SMTP id ff1so6626138vbb.19 for ; Mon, 24 Sep 2012 14:10:18 -0700 (PDT) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=20120113; h=mime-version:date:message-id:subject:from:to:content-type :x-gm-message-state; bh=CuoMHpVLWkrsTP82n9q2LpthmjuAQGJyojGLc+34l10=; b=L82xeRADvh/4RdDJRNyArROgg9kRYpZ9O1caWx+n+KBknmNBV2iWY/CAkGL+c4fY1G 7Dg0rfMoBIpCLaHyFlFD9vW9HBl8zxUD3qfccLiWmdXB7dihI9MNLXFlDRPdJOE/qST+ OkpMCY0G3ekB0bgI33IIExx5ofdyIEMwVZJNK/Pz9TiGpXKiIARPfrxtLmU7sPtaTvIn UMoqYgYWH/urrZRn+PrSMMN7Ixa9s8L8EK9WQkVCoTWLvBBIy2E+bK6HYysYfR1is/Rl 9m3H8hqGthziE7+Y82/H/ZRKvpB1x7IhO5Ovp29kA02MS2+e4bpUvX/ZsvACMmFIzxk/ ygPg== MIME-Version: 1.0 Received: by 10.220.223.3 with SMTP id ii3mr8024972vcb.74.1348521017983; Mon, 24 Sep 2012 14:10:17 -0700 (PDT) Received: by 10.58.249.178 with HTTP; Mon, 24 Sep 2012 14:10:17 -0700 (PDT) Date: Mon, 24 Sep 2012 16:10:17 -0500 Message-ID: Subject: dropping a large table is taking a very long time (about 2 hours so far) From: Evan Walter To: pgsql-admin@postgresql.org Content-Type: multipart/alternative; boundary=14dae9cdc8bb3fc3b804ca7904f8 X-Gm-Message-State: ALoCoQnVJ4o7oGu+XAWf11btIGeUPQGLmnzclB1HtcP20dwCERBNQnf13lwVVMrtpX8sCUBvBatj X-Pg-Spam-Score: -4.2 (----) X-Archive-Number: 201209/139 X-Sequence-Number: 40080 --14dae9cdc8bb3fc3b804ca7904f8 Content-Type: text/plain; charset=ISO-8859-1 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? --14dae9cdc8bb3fc3b804ca7904f8 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable There were probaby about 5 million records in the table.=A0 I do not believ= e there were any foreign keys to the table=A0 The drop table has been going= for over 2 hours.=A0 Is that normal?
--14dae9cdc8bb3fc3b804ca7904f8--