Re: slow DDL creation

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Kevin Kempter <cs_dba(at)consistentstate(dot)com>
Cc: bricklen <bricklen(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: slow DDL creation
Date: 2010-09-21 19:38:59
Message-ID: AANLkTim9mowNzcgpRPv3ze4XQ8qo161BZskEG=fNZida@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Tue, Aug 31, 2010 at 11:35 AM, Kevin Kempter
<cs_dba(at)consistentstate(dot)com> wrote:
> 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

What exactly does "stinks" mean?

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise Postgres Company

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Ozer, Pam 2010-09-21 20:04:01 Re: Using Between
Previous Message Robert Haas 2010-09-21 19:35:20 Re: Using Between