On Tue, Aug 31, 2010 at 11:35 AM, Kevin Kempter
<cs_dba@consistentstate.com> wrote:
> On Monday 30 August 2010 17:04, bricklen wrote:
>> On Mon, Aug 30, 2010 at 3:28 PM, Kevin Kempter
>>
>> <cs_dba@consistentstate.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