Re: Delete query takes exorbitant amount of time

From: Vivek Khera <vivek(at)khera(dot)org>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Delete query takes exorbitant amount of time
Date: 2005-03-25 03:56:34
Message-ID: d30da0f06db2572b87edc2c9cf01aa89@khera.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Josh Berkus 2005-03-25 05:24:39 Re: Delete query takes exorbitant amount of time
Previous Message Christopher Kings-Lynne 2005-03-25 03:38:37 Re: Delete query takes exorbitant amount of time