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

Re: slow DDL creation

From: bricklen <bricklen(at)gmail(dot)com>
To: Kevin Kempter <cs_dba(at)consistentstate(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: slow DDL creation
Date: 2010-08-30 23:04:20
Message-ID: AANLkTi=bV1PD1n=OAwpmP0ce96WBnFumHW-FUo7MdyJ2@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
On Mon, Aug 30, 2010 at 3:28 PM, Kevin Kempter
<cs_dba(at)consistentstate(dot)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?

In response to

Responses

pgsql-performance by date

Next:From: David FetterDate: 2010-08-31 00:31:13
Subject: Re: slow DDL creation
Previous:From: David BorehamDate: 2010-08-30 22:37:14
Subject: Re: GPU Accelerated Sorting

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