Postgres Pro
Downloads
Home   >   mailing lists

slow DDL creation - Mailing list pgsql-performance

From Kevin Kempter
Subject slow DDL creation
Date
Msg-id 201008301628.25687.cs_dba@consistentstate.com
Whole thread Raw
Responses Re: slow DDL creation
Re: slow DDL creation
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: Chris Browne
Date:
Subject: Re: GPU Accelerated Sorting
Next
From: Greg Smith
Date:
Subject: Re: Performance on new 64bit server compared to my 32bit desktop