pgsql: Delay build of Memoize hash table until executor run

From: David Rowley <drowley(at)postgresql(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Delay build of Memoize hash table until executor run
Date: 2024-01-29 23:37:21
Message-ID: E1rUbBp-003kqm-8i@gemulon.postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Delay build of Memoize hash table until executor run

Previously this hash table was built during executor startup. This
could cause long delays in EXPLAIN (without ANALYZE) when the planner
opts to use a large Memoize hash table.

No backpatch for now due to lack of complaints.

Author: David Rowley
Discussion: https://postgr.es/m/CAApHDvoJktJ5XL=Kjh2a2TFr64R-7eQZV-+jcJrUwoES2GLiWg@mail.gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/57f59396bb51953bb7b957780c7f1b7f67602125

Modified Files
--------------
src/backend/executor/nodeMemoize.c | 27 ++++++++++++++++++++-------
1 file changed, 20 insertions(+), 7 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Peter Eisentraut 2024-01-30 08:16:03 pgsql: Fix incorrect format placeholders for Oid
Previous Message David Rowley 2024-01-29 21:17:52 pgsql: Doc: mention foreign keys can reference unique indexes