Re: Add estimated hit ratio to Memoize in EXPLAIN to explain cost adjustment
Ilia Evdokimov <ilya.evdokimov@tantorlabs.com>
From: Ilia Evdokimov <ilya.evdokimov@tantorlabs.com>
To: David Rowley <dgrowleyml@gmail.com>, Robert Haas <robertmhaas@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Lukas Fittl <lukas@fittl.com>,
Daniel Gustafsson <daniel@yesql.se>,
PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>,
Nikolay Samokhvalov <samokhvalov@gmail.com>,
Andrei Lepikhov <lepihov@gmail.com>
Date: 2025-04-14T23:14:37Z
Lists: pgsql-hackers
Attachments
On 14.04.2025 23:53, David Rowley wrote: > If we can't get consensus for everything people want to add at once > then maybe the patch could be broken into two, with 0001 being pretty > much the v4 patch and then have 0002 add the Estimated Hit Ratio. > Having the physical patches and being able to try it out or view the > regression test changes might lower the bar on people chipping in with > their views. Agreed - I’ll split the patch into two: one adds Estimated Capacity and Estimated Distinct Keys, and the second adds Estimated Hit Ratio. I’ll also add regression test differences to make it easier to evaluate the usefulness of each part. -- Best regards, Ilia Evdokimov, Tantor Labs LLC.