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

Re: slow DDL creation

From: Kevin Kempter <cs_dba(at)consistentstate(dot)com>
To: bricklen <bricklen(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: slow DDL creation
Date: 2010-08-31 15:35:14
Message-ID: 201008310935.14919.cs_dba@consistentstate.com (view raw or flat)
Thread:
Lists: pgsql-performance
On Monday 30 August 2010 17:04, bricklen wrote:
> 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?

no, but its for a new partition so there's no data as of yet in the partition

In response to

Responses

pgsql-performance by date

Next:From: Greg SmithDate: 2010-08-31 15:43:41
Subject: Re: Performance on new 64bit server compared to my 32bit desktop
Previous:From: Yeb HavingaDate: 2010-08-31 12:41:42
Subject: Re: Performance on new 64bit server compared to my 32bit desktop

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