Re: [patch]HashJoin crash

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Zhang Mingli <zmlpostgres@gmail.com>
Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2022-08-13T21:01:47Z
Lists: pgsql-hackers
Zhang Mingli <zmlpostgres@gmail.com> writes:
> In ExecChooseHashTableSize(), commit b154ee63bb uses func pg_nextpower2_size_t
> whose param must not be 0.

Right.  Fix pushed, thanks.

			regards, tom lane



Commits

  1. Avoid misbehavior when hash_table_bytes < bucket_size.

  2. Get rid of artificial restriction on hash table sizes on Windows.