Re: QUAL Pushdown causes ERROR on syntactically and semantically correct SQL Query

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: QUAL Pushdown causes ERROR on syntactically and semantically correct SQL Query
Дата
Msg-id CAKFQuwZUh4Tn5aJerXuQjRn221xhTbgRqUF14Ng42FYaOrWu2Q@mail.gmail.com
обсуждение исходный текст
Ответ на QUAL Pushdown causes ERROR on syntactically and semantically correct SQL Query  (Hans Buschmann <buschmann@nidsa.net>)
Список pgsql-hackers
On Mon, Jun 5, 2023, 07:40 Hans Buschmann <buschmann@nidsa.net> wrote:

I have reworked the case of BUG #17842 to include the data and the questions for further investigation.


The problem is NOT to correct the query to a working case, but to show a fundamental problem with qual pushdown.


The optimization system operates with imperfect information, meaning it assumes expressions do not produce errors depending on the data.  If you know certain data can produce errors you need to add the relevant code to avoid evaluating those expressions on those data.

Yes, or would nice if PostgreSQL could do better here.  The cost of doing so is quite high though, and there is no interest in incurring that cost.

David J.


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

Предыдущее
От: Heikki Linnakangas
Дата:
Сообщение: Let's make PostgreSQL multi-threaded
Следующее
От: Tom Lane
Дата:
Сообщение: Re: QUAL Pushdown causes ERROR on syntactically and semantically correct SQL Query