On Monday 30 August 2010 17:04, bricklen wrote: > On Mon, Aug 30, 2010 at 3:28 PM, Kevin Kempter > > <cs_dba@xxxxxxxxxxxxxxxxxxx> 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
