DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=default;
	d=consistentstate.com;
	h=Received:From:Organization:To:Subject:Date:User-Agent:Cc:References:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding:Content-Disposition:Message-Id:X-Identified-User;
	b=CBUGRI0+/Xdjyv8nQp2aB2D/UVKX5fcrrOJZwpZpgsqVqYSBIjStRE4akk5wbmyhvtgR28aRMEGxVRusaoWmQE4SdOK8JHrRqn2JhMn2KefHvA4C7pcx6p4+sKZi77TC;
From: Kevin Kempter <cs_dba@consistentstate.com>
Organization: Consistent State
To: bricklen <bricklen@gmail.com>
Subject: Re: slow DDL creation
Date: Tue, 31 Aug 2010 09:35:14 -0600
User-Agent: KMail/1.9.4
Cc: pgsql-performance@postgresql.org
References: <201008301628.25687.cs_dba@consistentstate.com>
	<AANLkTi=bV1PD1n=OAwpmP0ce96WBnFumHW-FUo7MdyJ2@mail.gmail.com>
In-Reply-To: <AANLkTi=bV1PD1n=OAwpmP0ce96WBnFumHW-FUo7MdyJ2@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="utf-8"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
Message-Id: <201008310935.14919.cs_dba@consistentstate.com>

On Monday 30 August 2010 17:04, bricklen wrote:
> 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? =C2=A0were running postg=
res
> > 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 partiti=
on