Re: accounting for memory used for BufFile during hash joins
Tomas Vondra <tomas.vondra@2ndquadrant.com>
From: Tomas Vondra <tomas.vondra@2ndquadrant.com>
To: Michael Paquier <michael@paquier.xyz>
Cc: Melanie Plageman <melanieplageman@gmail.com>, Alvaro Herrera <alvherre@2ndquadrant.com>, Hubert Zhang <hzhang@pivotal.io>, hackers <pgsql-hackers@postgresql.org>, Thomas Munro <thomas.munro@gmail.com>
Date: 2019-11-25T18:11:19Z
Lists: pgsql-hackers
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. regards -- Tomas Vondra http://www.2ndQuadrant.com PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
Commits
-
Consider BufFiles when adjusting hashjoin parameters
- a1b4f289beec 18.0 landed