Re: Defer selection of asynchronous subplans until the executor initialization stage

Etsuro Fujita <etsuro.fujita@gmail.com>

From: Etsuro Fujita <etsuro.fujita@gmail.com>

To: Justin Pryzby <pryzby@telsasoft.com>

Cc: Zhihong Yu <zyu@yugabyte.com>, Alexander Pyhalov <a.pyhalov@postgrespro.ru>, "Andrey V. Lepikhov" <a.lepikhov@postgrespro.ru>, Kyotaro Horiguchi <horikyota.ntt@gmail.com>, pgsql-hackers@lists.postgresql.org

Date: 2022-04-08T16:58:53Z

Lists: pgsql-hackers

Hi,

On Fri, Apr 8, 2022 at 9:43 PM Justin Pryzby <pryzby@telsasoft.com> wrote:
> This patch seems to be causing the planner to crash.
> Here's a query reduced from sqlsmith.
>
> | explain SELECT 1 FROM information_schema.constraint_column_usage WHERE 1 <= pg_trigger_depth();
>
> Program terminated with signal SIGSEGV, Segmentation fault.

Reproduced.  Will look into this.

Thanks for the report!

Best regards,
Etsuro Fujita

Commits

Improve comments for trivial_subqueryscan().
- 4a8a5dd7f59c 15.0 landed
Disable asynchronous execution if using gating Result nodes.
- ebb790241523 14.3 landed
- 5c854e7a2c8a 15.0 landed
Allow asynchronous execution in more cases.
- c2bb02bc2e85 15.0 landed
Doc: Further update documentation for asynchronous execution.
- eab81953682d 14.0 landed
Fix rescanning of async-aware Append nodes.
- f3baaf28a6da 14.0 landed
Doc: Update documentation for asynchronous execution.
- 15fcd33e0694 14.0 landed
Fix EXPLAIN ANALYZE for async-capable nodes.
- a363bc6da96b 14.0 landed
Minor code cleanup in asynchronous execution support.
- bb684c82f733 14.0 landed
Adjust input value to WaitEventSetWait() in ExecAppendAsyncEventWait().
- a8af856d3257 14.0 landed
Add support for asynchronous execution.
- 27e1f14563cf 14.0 landed