Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 36BA6632829 for ; Mon, 30 Aug 2010 21:31:24 -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 59454-03 for ; Tue, 31 Aug 2010 00:31:15 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from fetter.org (mail.fetter.org [64.81.66.25]) by mail.postgresql.org (Postfix) with ESMTP id AE0B363223F for ; Mon, 30 Aug 2010 21:31:16 -0300 (ADT) Received: by fetter.org (Postfix, from userid 500) id E0384FBC9D8; Mon, 30 Aug 2010 17:31:13 -0700 (PDT) Date: Mon, 30 Aug 2010 17:31:13 -0700 From: David Fetter To: Kevin Kempter Cc: pgsql-performance@postgresql.org Subject: Re: slow DDL creation Message-ID: <20100831003113.GB9206@fetter.org> References: <201008301628.25687.cs_dba@consistentstate.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <201008301628.25687.cs_dba@consistentstate.com> User-Agent: Mutt/1.5.20 (2009-12-10) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-10 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201008/346 X-Sequence-Number: 40189 On Mon, Aug 30, 2010 at 04:28:25PM -0600, Kevin Kempter wrote: > 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 If you're doing the partitions on demand, you could be getting deadlocks. Any reason not to pre-create a big bunch of them in advance? Cheers, David. -- David Fetter http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fetter@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate