Re: slow DDL creation - Mailing list pgsql-performance

From bricklen
Subject Re: slow DDL creation
Date
Msg-id AANLkTi=bV1PD1n=OAwpmP0ce96WBnFumHW-FUo7MdyJ2@mail.gmail.com
Whole thread Raw
In response to slow DDL creation  (Kevin Kempter <cs_dba@consistentstate.com>)
Responses Re: slow DDL creation  (Kevin Kempter <cs_dba@consistentstate.com>)
List pgsql-performance
On Mon, Aug 30, 2010 at 3:28 PM, Kevin Kempter
<cs_dba@consistentstate.com> 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
>
> Thanks in advance

Is the referenced column indexed?

pgsql-performance by date:

Previous
From: David Boreham
Date:
Subject: Re: GPU Accelerated Sorting
Next
From: David Fetter
Date:
Subject: Re: slow DDL creation