Horton

Re: strange slow query - lost lot of time somewhere

Pavel Stehule <pavel.stehule@gmail.com>

View thread View on postgr.es
From: Pavel Stehule <pavel.stehule@gmail.com>
To: David Rowley <dgrowleyml@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:14:32Z
Lists: pgsql-hackers 
po 16. 5. 2022 v 6:11 odesílatel David Rowley <dgrowleyml@gmail.com> napsal:

> 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.
>

Thank you

Pavel


>
> 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