Re: Delete query takes exorbitant amount of time - Mailing list pgsql-performance

From Vivek Khera
Subject Re: Delete query takes exorbitant amount of time
Date
Msg-id d30da0f06db2572b87edc2c9cf01aa89@khera.org
Whole thread Raw
In response to Re: Delete query takes exorbitant amount of time  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
List pgsql-performance
On Mar 24, 2005, at 10:38 PM, Christopher Kings-Lynne wrote:

>> In that case there's a datatype mismatch between the referencing and
>> referenced columns, which prevents the index from being used for the
>> FK check.
>
> Is creating such a foreign key a WARNING yet?
>

I recall getting such a warning when importing my schema from a 7.4 to
8.0 server.  I had one table with char and the other with varchar.


pgsql-performance by date:

Previous
From: Christopher Kings-Lynne
Date:
Subject: Re: Delete query takes exorbitant amount of time
Next
From: Josh Berkus
Date:
Subject: Re: Delete query takes exorbitant amount of time