Re: strange slow query - lost lot of time somewhere

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

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

To: Pavel Stehule <pavel.stehule@gmail.com>

Cc: David Rowley <dgrowleyml@gmail.com>, Jakub Wartak <Jakub.Wartak@tomtom.com>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>

Date: 2022-05-06T06:00:57Z

Lists: pgsql-hackers

Pavel Stehule <pavel.stehule@gmail.com> writes:
> Breakpoint 1, build_hash_table (size=4369066, mstate=0xfc7f08) at
> nodeMemoize.c:268
> 268 if (size == 0)
> (gdb) p size
> $1 = 4369066

Uh-huh ....

			regards, tom lane

Commits

Correct Memoize's estimated cache hit ratio calculation
- f48b4f892f76 16.0 landed
Fix incorrect row estimates used for Memoize costing
- 23c2b76a8322 14.4 landed
- 1e731ed12aac 15.0 landed
Allow Memoize to operate in binary comparison mode
- 6c32c0977783 14.2 cited