Re: accounting for memory used for BufFile during hash joins

From: Melanie Plageman <melanieplageman(at)gmail(dot)com>
To: Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>
Cc: Michael Paquier <michael(at)paquier(dot)xyz>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Hubert Zhang <hzhang(at)pivotal(dot)io>, hackers <pgsql-hackers(at)postgresql(dot)org>, Thomas Munro <thomas(dot)munro(at)gmail(dot)com>
Subject: Re: accounting for memory used for BufFile during hash joins
Date: 2020-01-03 17:44:58
Message-ID: CAAKRu_Ya1gFNDcQZ5SwV3fSzQ47rXe2zprMjkRa9WGeoBjuvNw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, Nov 25, 2019 at 10:11 AM Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>
wrote:

> On Mon, Nov 25, 2019 at 05:33:35PM +0900, Michael Paquier wrote:
> >On Tue, Sep 10, 2019 at 03:47:51PM +0200, Tomas Vondra wrote:
> >> My feeling is that we should get the BNLJ committed first, and then
> maybe
> >> use some of those additional strategies as fallbacks (depending on which
> >> issues are still unsolved by the BNLJ).
> >
> >The glacier is melting more. Tomas, what's your status here? The
> >patch has been waiting on author for two months now. If you are not
> >planning to work more on this one, then it should be marked as
> >returned with feedback?
>
> I'm not planning to do any any immediate work on this, so I agree with
> marking it as RWF. I think Melanie is working on the BNL patch, which
> seems like the right solution.
>
>
Sorry for the delay. I have posted the parallel-aware version BNLJ
(adaptive HJ) of this in the thread which originally had all of the
patches for it [1]. It's not near committable, so I wasn't going to
register it for a commitfest yet, but I would love feedback on the
prototype.

[1]
https://www.postgresql.org/message-id/CAAKRu_YsWm7gc_b2nBGWFPE6wuhdOLfc1LBZ786DUzaCPUDXCA%40mail.gmail.com
--
Melanie Plageman

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Christoph Berg 2020-01-03 17:48:39 Re: pgsql: Add basic TAP tests for psql's tab-completion logic.
Previous Message Robert Haas 2020-01-03 17:37:47 Re: backup manifests