Horton

Re: strange slow query - lost lot of time somewhere

David Rowley <dgrowleyml@gmail.com>

View thread View on postgr.es
From: David Rowley <dgrowleyml@gmail.com>
To: Pavel Stehule <pavel.stehule@gmail.com>
Cc: Jakub Wartak <Jakub.Wartak@tomtom.com>, Tom Lane <tgl@sss.pgh.pa.us>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2022-05-16T04:10:54Z
Lists: pgsql-hackers 
On Fri, 6 May 2022 at 21:27, David Rowley <dgrowleyml@gmail.com> wrote:
> I've attached a patch to fix.  I'll look at it in more detail after the weekend.

I've now pushed this fix to master and backpatched to 14.

David

Commits

  1. Correct Memoize's estimated cache hit ratio calculation

  2. Fix incorrect row estimates used for Memoize costing

  3. Allow Memoize to operate in binary comparison mode