Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ir2nO-0001Tp-DY for pgsql-performance@arkaria.postgresql.org; Mon, 13 Jan 2020 16:42:30 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1ir2nM-00054X-W5 for pgsql-performance@arkaria.postgresql.org; Mon, 13 Jan 2020 16:42:28 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ir2nM-00054J-Ed for pgsql-performance@lists.postgresql.org; Mon, 13 Jan 2020 16:42:28 +0000 Received: from mail-yw1-xc2d.google.com ([2607:f8b0:4864:20::c2d]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1ir2nH-0008DW-Cj for pgsql-performance@postgresql.org; Mon, 13 Jan 2020 16:42:26 +0000 Received: by mail-yw1-xc2d.google.com with SMTP id l22so6528693ywc.8 for ; Mon, 13 Jan 2020 08:42:23 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=telsasoft-com.20150623.gappssmtp.com; s=20150623; h=date:from:to:cc:subject:message-id:references:mime-version :content-disposition:in-reply-to:user-agent; bh=NGqXqvFyf4pG9uUezNqPBZtCGYlzw8Vz7vC9gIc7Xpo=; b=YL3WGE7onJen5INiKXiWNXi73pvL8DhBegn57SvRjp7574jjoViUeiyJtooZDkEA6e Ng/4eB7dM/kWmI0VT7MI980pznayysTjozGbisK3EP0uDKW/rrBkEQl0wFxV0Ygj9pwK DgM/nCT6DI6KL6/kfkq6Yck3BK+NI/K/IklPEMJI491YYG37K5wmY0rZ1GyTWgK/vGAN CA/ZhMisMDq49WR2Wxh+KyAB+bEPGLHmAhgIo2cHI0jz9MS58LuIJ34fi6VZn5Y6AKKW iaQSmfsj5ijJoMIgTASFjKwu0pTrr04QINeSy1VhkTNiOVyy/lySpZapJC3MKN164c3y 5raQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:date:from:to:cc:subject:message-id:references :mime-version:content-disposition:in-reply-to:user-agent; bh=NGqXqvFyf4pG9uUezNqPBZtCGYlzw8Vz7vC9gIc7Xpo=; b=B59YPX4R+y3sbnd1q1GvlCzkRwpA+qT0Plo1PJy2oQhG7PM6dHV0JiH7mEbtLJ/eS3 D1MrKul3Z/p1AG8cMP3ghnF7nnDLq1yWHn5ZK0A6F4mGjvjDzLIXBtHb6cZNr+fTM2D0 MarKgjA/wdvQmSNR4BH+kN32CrTm3+Xb53H3XDiLSHFi5mbh3kqsq7BM9NfomAiHnkbw vTzACsQIT8fZuwlwsScZu41k/nh3Cezm8RwSLyqkiiEeKV3qDnBx51vxDZ8+WH4OHTpg IJ6o7lmFX8ckjhhzQdPlS+/EH+1cHWsZoPM1WaJigrd59AVcyMV/PJtHy/iqoYwTisEi Dfbw== X-Gm-Message-State: APjAAAW+Lr3jiHxl96Wm5nNG8fOASHNZ2d0ADLV6g8v+/2Gf7DATAGGD +1XkKjorDZxpQgE+dzB7nrTQex1oCfY= X-Google-Smtp-Source: APXvYqy0nWbYhDHpBsrAg3kVV4YE6dlIMzhVU/YrQr3S7wN8ZaGx0z6JAKo3fVedCTwo1N/Te6z21A== X-Received: by 2002:a81:c20e:: with SMTP id z14mr14762118ywc.384.1578933742271; Mon, 13 Jan 2020 08:42:22 -0800 (PST) Received: from pryzbyj (charmander.telsasoft.com. [50.244.222.1]) by smtp.gmail.com with ESMTPSA id l5sm5316310ywd.48.2020.01.13.08.42.21 (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Mon, 13 Jan 2020 08:42:21 -0800 (PST) Received: by pryzbyj (Postfix, from userid 1000) id 56DD68009F4; Mon, 13 Jan 2020 10:42:20 -0600 (CST) Date: Mon, 13 Jan 2020 10:42:20 -0600 From: Justin Pryzby To: Shira Bezalel Cc: pgsql-performance@postgresql.org Subject: Re: Seeking reason behind performance gain in 12 with HashAggregate Message-ID: <20200113164220.GH26045@telsasoft.com> References: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.24 (2015-08-30) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On Mon, Jan 13, 2020 at 08:29:05AM -0800, Shira Bezalel wrote: > Here is the EXPLAIN (ANALYZE ON, BUFFERS ON) output from both systems: > > 9.6 plan > 12.1 plan > Is there something that was changed/improved in either 10, 11 or 12 that this > behavior can be attributed to? v12 has JIT enabled by default. You can test if that's significant with SET jit=off.