Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size

Поиск
Список
Период
Сортировка
Искать
От
Andres Freund
Тема
Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size
Дата
Msg-id
20230223193953.3uemxkjbz4gjsb4v@awork3.anarazel.de
Ответ на
Список
Дерево обсуждения
PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size Andres Freund <andres@anarazel.de>
Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size Tom Lane <tgl@sss.pgh.pa.us>
Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size Tom Lane <tgl@sss.pgh.pa.us>
Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size Andres Freund <andres@anarazel.de>
Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size Corey Huinker <corey.huinker@gmail.com>
Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size Andres Freund <andres@anarazel.de>
Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size Tom Lane <tgl@sss.pgh.pa.us>
Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size Andres Freund <andres@anarazel.de>
Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size Corey Huinker <corey.huinker@gmail.com>
Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size Andres Freund <andres@anarazel.de>
Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size David Rowley <dgrowleyml@gmail.com>
Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size Andres Freund <andres@anarazel.de>
Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size David Rowley <dgrowleyml@gmail.com>
Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size James Coleman <jtc331@gmail.com>
Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size Peter Geoghegan <pg@bowt.ie>
Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size David Rowley <dgrowleyml@gmail.com>
Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size Andres Freund <andres@anarazel.de>
Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size Andres Freund <andres@anarazel.de>
Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size Tom Lane <tgl@sss.pgh.pa.us>
Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size Tom Lane <tgl@sss.pgh.pa.us>
Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size Andres Freund <andres@anarazel.de>
Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size Tom Lane <tgl@sss.pgh.pa.us>
Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size Andres Freund <andres@anarazel.de>
Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size Andres Freund <andres@anarazel.de>
Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size Andrew Dunstan <andrew@dunslane.net>
Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size Andres Freund <andres@anarazel.de>
Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size Andrew Dunstan <andrew@dunslane.net>
Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size Michael Paquier <michael@paquier.xyz>
Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size Andres Freund <andres@anarazel.de>
Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size Andres Freund <andres@anarazel.de>
Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size Andrew Dunstan <andrew@dunslane.net>
Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size Andres Freund <andres@anarazel.de>
Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size Andrew Dunstan <andrew@dunslane.net>
Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size Andrew Dunstan <andrew@dunslane.net>
Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size Andres Freund <andres@anarazel.de>
Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size Andres Freund <andres@anarazel.de>
Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size Andrew Dunstan <andrew@dunslane.net>
Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size Amit Langote <amitlangote09@gmail.com>
Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size Andres Freund <andres@anarazel.de>
Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size Amit Langote <amitlangote09@gmail.com>
Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size Amit Langote <amitlangote09@gmail.com>
Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size Amit Langote <amitlangote09@gmail.com>
Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size David Rowley <dgrowleyml@gmail.com>
Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size Amit Langote <amitlangote09@gmail.com>
Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size Amit Langote <amitlangote09@gmail.com>
Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size Andrew Dunstan <andrew@dunslane.net>
Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size Andres Freund <andres@anarazel.de>
Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size Andres Freund <andres@anarazel.de>
Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size Amit Langote <amitlangote09@gmail.com>
Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size Andres Freund <andres@anarazel.de>
Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size Amit Langote <amitlangote09@gmail.com>
Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size Andres Freund <andres@anarazel.de>
Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size "Jonathan S. Katz" <jkatz@postgresql.org>
Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size Andrew Dunstan <andrew@dunslane.net>
Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size "Jonathan S. Katz" <jkatz@postgresql.org>
Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size Andres Freund <andres@anarazel.de>
Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size "Jonathan S. Katz" <jkatz@postgresql.org>
Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size Amit Langote <amitlangote09@gmail.com>
Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size "Jonathan S. Katz" <jkatz@postgresql.org>
Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size Andres Freund <andres@anarazel.de>
Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size Tom Lane <tgl@sss.pgh.pa.us>
Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size Andres Freund <andres@anarazel.de>
Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size "Jonathan S. Katz" <jkatz@postgresql.org>
Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size Andrew Dunstan <andrew@dunslane.net>
Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size "Jonathan S. Katz" <jkatz@postgresql.org>
Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size Andrew Dunstan <andrew@dunslane.net>
Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size Amit Langote <amitlangote09@gmail.com>
Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size Amit Langote <amitlangote09@gmail.com>
Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size David Rowley <dgrowleyml@gmail.com>
Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size Andres Freund <andres@anarazel.de>
Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size David Rowley <dgrowleyml@gmail.com>
Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Hi,

On 2023-02-23 13:56:56 -0500, Tom Lane wrote:
> Corey Huinker  writes:
> > My not-ready-for-16 work on CAST( ... ON DEFAULT ... ) involved making
> > FuncExpr/IoCoerceExpr/ArrayCoerceExpr have a safe_mode flag, and that
> > necessitates adding a reserror boolean to ExprEvalStep for subsequent steps
> > to test if the error happened.
> 
> Why do you want it in ExprEvalStep ... couldn't it be in ExprState?
> I can't see why you'd need more than one at a time during evaluation.

I don't know exactly what CAST( ... ON DEFAULT ... ) is aiming for - I guess
it wants to assign a different value when the cast fails?  Is the default
expression a constant, or does it need to be runtime evaluated?  If a const,
then the cast steps just could assign the new value. If runtime evaluation is
needed I'd expect the various coerce steps to jump to the value implementing
the default expression in case of a failure.

So I'm not sure we even need a reserror field in ExprState.

Greetings,

Andres Freund


В списке pgsql-hackers по дате отправления
От: Andres Freund
Дата:
От: Kirk Wolak
Дата:
FAQ