Re: delete to slow

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: delete to slow
Дата
Msg-id 28823.1112811339@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: delete to slow  ("Jim C. Nasby" <decibel@decibel.org>)
Ответы Re: delete to slow
Список pgsql-admin
"Jim C. Nasby" <decibel@decibel.org> writes:
> Well, neither of those should take very long at all. What's EXPLAIN
> ANALYZE show?

Indeed ... now I'm wondering about foreign key checks.  Are there any
tables with foreign keys linking to usuario?  If so, the problem is
likely unindexed foreign key columns, or maybe a datatype mismatch
between foreign key and referenced column.

            regards, tom lane

В списке pgsql-admin по дате отправления: