Horton

Re: Hybrid Hash/Nested Loop joins and caching results from subplans

David Rowley <dgrowleyml@gmail.com>

View thread View on postgr.es
From: David Rowley <dgrowleyml@gmail.com>
To: Ibrar Ahmed <ibrar.ahmad@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Andres Freund <andres@anarazel.de>, Konstantin Knizhnik <k.knizhnik@postgrespro.ru>, Andy Fan <zhihui.fan1213@gmail.com>, Alvaro Herrera <alvherre@alvh.no-ip.org>, PostgreSQL Developers <pgsql-hackers@lists.postgresql.org>
Date: 2021-03-10T23:17:55Z
Lists: pgsql-hackers

Attachments

On Fri, 5 Mar 2021 at 00:16, Ibrar Ahmed <ibrar.ahmad@gmail.com> wrote:
> This patch set no longer applies
> http://cfbot.cputube.org/patch_32_2569.log
>
> Can we get a rebase?

v14 should still apply.  I think the problem is that the CFbot at best
can only try and apply the latest .patch files that are on the thread
in alphabetical order of the filename. The bot is likely just trying
to apply the unrelated patch that was posted since I posted v14.

I've attached the v14 version again. Hopefully, that'll make the CFbot happy.

I'm also working on another version of the patch with slightly
different planner code. I hope to reduce the additional planner
overheads a bit with it. It should arrive here in the next day or two.

David

Commits

  1. Add Result Cache executor node (take 2)

  2. Add Result Cache executor node

  3. Allow estimate_num_groups() to pass back further details about the estimation

  4. Allow users of simplehash.h to perform direct deletions

  5. Cache if PathTarget and RestrictInfos contain volatile functions

  6. Fix pull_varnos' miscomputation of relids set for a PlaceHolderVar.