Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mQcDq-0007fp-Ml for pgsql-hackers@arkaria.postgresql.org; Wed, 15 Sep 2021 21:13:38 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mQcDI-00016K-RV for pgsql-hackers@arkaria.postgresql.org; Wed, 15 Sep 2021 21:13:04 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mQcDI-000160-Fk for pgsql-hackers@lists.postgresql.org; Wed, 15 Sep 2021 21:13:04 +0000 Received: from mail-qk1-x72a.google.com ([2607:f8b0:4864:20::72a]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1mQcDE-0004KU-Fw for pgsql-hackers@postgresql.org; Wed, 15 Sep 2021 21:13:04 +0000 Received: by mail-qk1-x72a.google.com with SMTP id bk29so5093142qkb.8 for ; Wed, 15 Sep 2021 14:12:59 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=systemguards-com-ec.20150623.gappssmtp.com; s=20150623; h=date:from:to:cc:subject:message-id:references:mime-version :content-disposition:in-reply-to:user-agent; bh=5jxk3QfRTuBjrzpR7323PAO5+1Ic/La/+LhbXionS5g=; b=ThmUZrS0UlQNzRthNnzVNrZcIchFaJpdBImVR+ZsYckMmF81mL2Yp4Wra1oJ50EI9Y 8SS8eW3SPGfZcOmfSXZ2pAYGPmHYBBGRJevugY8HOKqs22rDJHo9r07+U7ExaVDSkF2T WJM6BJp3NaAE+HXE4VCYXku0eDFEOIx6KnvMSU1mSpwwUhj1p2Vs2c5paP33/zzfk/t5 lHMchZel5VPY7GG5QNTWieRuyQS6DDA/oRIm9xnObRn8icIb06bk6AC6RhrxMqf4JdHL QSbyu8I09LcA8X3+acJ573XcOle4HiI9XTsZDpfpWKTzy+zis0O52R/TPZBvrNmkzXRg a3QQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:date:from:to:cc:subject:message-id:references :mime-version:content-disposition:in-reply-to:user-agent; bh=5jxk3QfRTuBjrzpR7323PAO5+1Ic/La/+LhbXionS5g=; b=oBdAyzraBPrkLYPYjkRfBB8UR07jfuHM+ChdI6EGSIiObBkKstI6iptpJf/7GXyjh6 Kr9mgNr08j5OQuJxAIdVOfPtQWn2TEljQHhQsRUb27n/5CvZQGr1esBLLn8YajTrgdHe nTYLi7C6UyjiBgLHkj4UvcJ3PlJXh7OWLncpLq8eH5FB96hw6zQSBmMeiRIaOEpwKaUR T7JGzg461dS3kWmPDtESCXMhZatI8I+22/PjFQY7C5/atEILcSBiQ6gOe7Chgto/v57F D5Oi+X0/5TUS3uiLnz56cKzFuMe+csYEv6hO8pSzpHR1OWiJdWgnce49yUo1s2zYwo2F Y8lw== X-Gm-Message-State: AOAM531aIeXW2SwG6jY8JnywEjhfx/TRboFShTO93xfRIXYAfUyeRQ3d vfkxARjc5Udz1HWbdATLFFScAg== X-Google-Smtp-Source: ABdhPJykrEHuYuQcrvn2kge7DXMyFVLpQPGf6203TOeoimQEMliYCwzaeZ8LBtX9MrGgkmMPj/gFyA== X-Received: by 2002:ae9:d61a:: with SMTP id r26mr2059870qkk.162.1631740377239; Wed, 15 Sep 2021 14:12:57 -0700 (PDT) Received: from ahch-to ([201.183.0.184]) by smtp.gmail.com with ESMTPSA id w6sm930675qkw.91.2021.09.15.14.12.55 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 15 Sep 2021 14:12:56 -0700 (PDT) Date: Wed, 15 Sep 2021 16:12:53 -0500 From: Jaime Casanova To: Heikki Linnakangas Cc: vignesh C , pgsql-hackers , Peter Geoghegan , Tomas Vondra Subject: Re: Polyphase merge is obsolete Message-ID: <20210915211253.GA17635@ahch-to> References: <420a0ec7-602c-d406-1e75-1ef7ddc58d83@iki.fi> <264a0544-c4e9-315e-18fa-1afd9151e939@2ndquadrant.com> <6a15881f-0cc5-3564-abc0-03ec28883380@iki.fi> <4c6a8fd7-1902-fc8e-e8d6-281d426f5da8@iki.fi> <91284957-3cb2-944e-5f14-5c2ff86b49fa@iki.fi> <20210911063527.GB3770@ahch-to> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20210911063527.GB3770@ahch-to> User-Agent: Mutt/1.10.1 (2018-07-13) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Sat, Sep 11, 2021 at 01:35:27AM -0500, Jaime Casanova wrote: > On Wed, Jul 14, 2021 at 06:04:14PM +0300, Heikki Linnakangas wrote: > > On 14/07/2021 15:12, vignesh C wrote: > > > On Sat, Jan 23, 2021 at 3:49 AM Heikki Linnakangas wrote: > > > > Here's an updated version that fixes one bug: > > > > > > > > The CFBot was reporting a failure on the FreeBSD system [1]. It turned > > > > out to be an out-of-memory issue caused by an underflow bug in the > > > > calculation of the size of the tape read buffer size. With a small > > > > work_mem size, the memory left for tape buffers was negative, and that > > > > wrapped around to a very large number. I believe that was not caught by > > > > the other systems, because the other ones had enough memory for the > > > > incorrectly-sized buffers anyway. That was the case on my laptop at > > > > least. It did cause a big slowdown in the 'tuplesort' regression test > > > > though, which I hadn't noticed. > > > > > > > > The fix for that bug is here as a separate patch for easier review, but > > > > I'll squash it before committing. > > > > > > The patch does not apply on Head anymore, could you rebase and post a > > > patch. I'm changing the status to "Waiting for Author". > > > > Here's a rebased version. I also squashed that little bug fix from previous > > patch set. > > > > Hi, > > This patch does not apply, can you submit a rebased version? > BTW, I'm marking this one as "waiting on author" -- Jaime Casanova Director de Servicios Profesionales SystemGuards - Consultores de PostgreSQL