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: | Raw Message | Whole Thread | 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
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 |