On Tue, Aug 31, 2010 at 11:35 AM, Kevin Kempter <cs_dba@xxxxxxxxxxxxxxxxxxx> wrote: > 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 What exactly does "stinks" mean? -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise Postgres Company -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
