Re: Negative cache entries for memoize

2023-04-05 Thread Bruce Momjian
On Thu, Apr 6, 2023 at 09:23:31AM +1200, David Rowley wrote: > On Thu, 6 Apr 2023 at 03:12, Bruce Momjian wrote: > > During two presentations, I was asked if negative cache entries were > > created for cases where inner-side lookups returned no rows. > > > > It seems we don't do that. Has this b

Re: Negative cache entries for memoize

2023-04-05 Thread David Rowley
On Thu, 6 Apr 2023 at 03:12, Bruce Momjian wrote: > During two presentations, I was asked if negative cache entries were > created for cases where inner-side lookups returned no rows. > > It seems we don't do that. Has this been considered or is it planned? It does allow negative cache entries,

Negative cache entries for memoize

2023-04-05 Thread Bruce Momjian
I wrote an optimizer talk that explains memoize, slides 24-25: https://momjian.us/main/writings/pgsql/beyond.pdf#page=25 During two presentations, I was asked if negative cache entries were created for cases where inner-side lookups returned no rows. It seems we don't do that. Has this