Re: Delete query takes exorbitant amount of time

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Delete query takes exorbitant amount of time
Дата
Msg-id 23515.1111763837@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Delete query takes exorbitant amount of time  (Simon Riggs <simon@2ndquadrant.com>)
Ответы Re: Delete query takes exorbitant amount of time  (Simon Riggs <simon@2ndquadrant.com>)
Список pgsql-performance
Simon Riggs <simon@2ndquadrant.com> writes:
> I vote to make this an ERROR in 8.1 - I see little benefit in allowing
> this situation to continue.

Other than spec compliance, you mean?  SQL99 says

            ... The declared type of each referencing column shall be
            comparable to the declared type of the corresponding referenced
            column.

It doesn't say that it has to be indexable, and most definitely not that
there has to be an index.

            regards, tom lane

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

Предыдущее
От: Jack Xue
Дата:
Сообщение: Script for getting a table of reponse-time breakdown
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: [BUGS] BUG #1552: massive performance hit