From: Kevin Kempter <cs_dba@consistentstate.com>
To: bricklen <bricklen@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: slow DDL creation
Date: Tue, 31 Aug 2010 09:35:14 -0600
Message-ID: <201008310935.14919.cs_dba@consistentstate.com> (raw)
In-Reply-To: <AANLkTi=bV1PD1n=OAwpmP0ce96WBnFumHW-FUo7MdyJ2@mail.gmail.com>
References: <201008301628.25687.cs_dba@consistentstate.com>
<AANLkTi=bV1PD1n=OAwpmP0ce96WBnFumHW-FUo7MdyJ2@mail.gmail.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? 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: cs_dba@consistentstate.com, bricklen@gmail.com
Subject: Re: slow DDL creation
In-Reply-To: <201008310935.14919.cs_dba@consistentstate.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox