From: David Fetter <david@fetter.org>
To: Kevin Kempter <cs_dba@consistentstate.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: slow DDL creation
Date: Mon, 30 Aug 2010 17:31:13 -0700
Message-ID: <20100831003113.GB9206@fetter.org> (raw)
In-Reply-To: <201008301628.25687.cs_dba@consistentstate.com>
References: <201008301628.25687.cs_dba@consistentstate.com>
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 <david@fetter.org> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: david@fetter.org, cs_dba@consistentstate.com
Subject: Re: slow DDL creation
In-Reply-To: <20100831003113.GB9206@fetter.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox