Re: Delete query takes exorbitant amount of time

Поиск
Список
Период
Сортировка
От Vivek Khera
Тема Re: Delete query takes exorbitant amount of time
Дата
Msg-id d30da0f06db2572b87edc2c9cf01aa89@khera.org
обсуждение исходный текст
Ответ на Re: Delete query takes exorbitant amount of time  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Список 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 по дате отправления:

Предыдущее
От: Christopher Kings-Lynne
Дата:
Сообщение: Re: Delete query takes exorbitant amount of time
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: Delete query takes exorbitant amount of time