Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 219CA633CF3 for ; Mon, 30 Aug 2010 19:26:49 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 49962-03 for ; Mon, 30 Aug 2010 22:26:40 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from oproxy3-pub.bluehost.com (oproxy3-pub.bluehost.com [69.89.21.8]) by mail.postgresql.org (Postfix) with SMTP id 7ECF46321B4 for ; Mon, 30 Aug 2010 19:26:41 -0300 (ADT) Received: (qmail 11188 invoked by uid 0); 30 Aug 2010 22:26:37 -0000 Received: from unknown (HELO box498.bluehost.com) (66.147.242.98) by oproxy3.bluehost.com with SMTP; 30 Aug 2010 22:26:37 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=default; d=consistentstate.com; h=Received:From:Organization:To:Subject:Date:User-Agent:MIME-Version:Content-Type:Content-Transfer-Encoding:Content-Disposition:Message-Id:X-Identified-User; b=LRbHIfUxt9RFItNLPT/f9vUKiVeyjQg93PaHdtV+28tQFFTII1kU9wP38A9iZk7MHKIdwCC7eCVaEKtjNvX4p9Tsnpachz1ekZlIdIfPHu2mnAI0KoDYv1zzfTkI5r6N; Received: from 173-164-51-9-colorado.hfc.comcastbusiness.net ([173.164.51.9] helo=[192.168.1.136]) by box498.bluehost.com with esmtpsa (SSLv3:AES256-SHA:256) (Exim 4.69) (envelope-from ) id 1OqCoH-0006fZ-Hk; Mon, 30 Aug 2010 16:26:37 -0600 From: Kevin Kempter Organization: Consistent State To: pgsql-performance@postgresql.org Subject: slow DDL creation Date: Mon, 30 Aug 2010 16:28:25 -0600 User-Agent: KMail/1.9.4 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <201008301628.25687.cs_dba@consistentstate.com> X-Identified-User: {3049:box498.bluehost.com:consist3:consistentstate.com} {sentby:smtp auth 173.164.51.9 authed with kevink+consistentstate.com} X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201008/342 X-Sequence-Number: 40185 Hi all ; we have an automated partition creation process that includes the creation of an FK constraint. we have a few other servers with similar scenarios and this is the only server that stinks per when we create the new partitions. Anyone have any thoughts on how to debug this? were running postgres 8.4.4 on CentOS 5.5 Thanks in advance