Re: [PERFORM] slow DDL creation

2010-09-21 Thread Robert Haas
On Tue, Aug 31, 2010 at 11:35 AM, Kevin Kempter wrote: > On Monday 30 August 2010 17:04, bricklen wrote: >> On Mon, Aug 30, 2010 at 3:28 PM, Kevin Kempter >> >> wrote: >> > Hi all ; >> > >> > we have an automated partition creation process that includes the >> > creation of an FK constraint. we h

Re: [PERFORM] slow DDL creation

2010-08-31 Thread Kevin Kempter
On Monday 30 August 2010 17:04, bricklen wrote: > On Mon, Aug 30, 2010 at 3:28 PM, Kevin Kempter > > 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 th

Re: [PERFORM] slow DDL creation

2010-08-30 Thread David Fetter
On Mon, Aug 30, 2010 at 04:28:25PM -0600, Kevin Kempter 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

Re: [PERFORM] slow DDL creation

2010-08-30 Thread bricklen
On Mon, Aug 30, 2010 at 3:28 PM, Kevin Kempter 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.

[PERFORM] slow DDL creation

2010-08-30 Thread Kevin Kempter
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