Skip site navigation (1) Skip section navigation (2)

Re: slow DDL creation

From: David Fetter <david(at)fetter(dot)org>
To: Kevin Kempter <cs_dba(at)consistentstate(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: slow DDL creation
Date: 2010-08-31 00:31:13
Message-ID: 20100831003113.GB9206@fetter.org (view raw or flat)
Thread:
Lists: pgsql-performance
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(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david(dot)fetter(at)gmail(dot)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

In response to

pgsql-performance by date

Next:From: Scott CareyDate: 2010-08-31 01:17:48
Subject: Re: GPU Accelerated Sorting
Previous:From: bricklenDate: 2010-08-30 23:04:20
Subject: Re: slow DDL creation

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group