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 1qAx2j-0000bW-H4 for pgsql-hackers@arkaria.postgresql.org; Sun, 18 Jun 2023 18:22:29 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1qAx2h-0004wT-Ah for pgsql-hackers@arkaria.postgresql.org; Sun, 18 Jun 2023 18:22:27 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1qAx2g-0004vU-SS for pgsql-hackers@lists.postgresql.org; Sun, 18 Jun 2023 18:22:26 +0000 Received: from mail-ej1-x62c.google.com ([2a00:1450:4864:20::62c]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qAx2d-002uuJ-DB for pgsql-hackers@lists.postgresql.org; Sun, 18 Jun 2023 18:22:25 +0000 Received: by mail-ej1-x62c.google.com with SMTP id a640c23a62f3a-988aefaa44eso32978366b.2 for ; Sun, 18 Jun 2023 11:22:23 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb.com; s=google; t=1687112541; x=1689704541; h=content-transfer-encoding:in-reply-to:from:content-language :references:cc:to:subject:user-agent:mime-version:date:message-id :from:to:cc:subject:date:message-id:reply-to; bh=Cy2Sxxr/yQZ+VmPQw8G2PKNg7tZ+I0r23/X0LMsUC84=; b=EVhFrYU458F3aXin2ltKQsJz2ABwzSTc1lMIodstBe7Cxkcv+i7SOM4MPVztUFDI0g 87io61MuJKYAjW0jPNi+5v7/J0bD43ZEbXB0u5Z3qLkuUXkzuvM2KiKz+HZPyTk7VDc2 67qK0eHC+Qe76Ay6KbbnZDJlDPe6q/hgGG0G2HvHZO31kJyudTlPYhanmVl4GVVykUqd 89bmaC9SkcYJaj+PKJW6XU6CzXaccj1gilhD++PAcRAdOx5G0PZDWyOyxuDFAsMrm7nV gfJLTQbRToFmQDhYP9oMUU+XMBiVabmHroHd3q3utr023ptPHkg1NCqA9W4+dcYjtuFI UdkQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1687112541; x=1689704541; h=content-transfer-encoding:in-reply-to:from:content-language :references:cc:to:subject:user-agent:mime-version:date:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=Cy2Sxxr/yQZ+VmPQw8G2PKNg7tZ+I0r23/X0LMsUC84=; b=A7BVS03wXBelZwLAFdSTmIZujSs8jh80NPjBEmIIgpFsVX120g7pifh/SAj49XjvIq VSPhp/UrTk/7hfl1xBktA372wE/FxHpkfuc4yFq66AU6i39suCi3S7yJoJzRlLGUvNLv jAZrszEqja9cgpAMEf9YPTwoh2/ZnZJbkjHffKXxr8Mdp2ZoC4HV0B29yLch5rPdHDF7 ZX/ywOmvCCYrJPWjy4tBxZrxfvExbwf68z3JR85+vnG+hc1ODHMe8VF9+lRmXaCSvKpn DhuA80feXonyAR7tgbpty6HKnbSTKBnIGSudw64h4odmDp9tVV24Po10L3c5G18Nzbur s4VA== X-Gm-Message-State: AC+VfDwMLgwDnt2768ZiydKdWdopnbwRnp3t/s6+d8YafrDQVNGRsjN7 No2xTGklItFv8gWkzXQmosJ2xg== X-Google-Smtp-Source: ACHHUZ4m440U+im1cpIu8AstCu3T6a/9ORBp1rYcM96l+jbdvpfhh6QwT5owWnHGtk1lYrsdIl5/Yg== X-Received: by 2002:a17:907:c23:b0:988:7428:2c15 with SMTP id ga35-20020a1709070c2300b0098874282c15mr2401506ejc.5.1687112540545; Sun, 18 Jun 2023 11:22:20 -0700 (PDT) Received: from [10.137.0.17] (ip-86-49-228-220.bb.vodafone.cz. [86.49.228.220]) by smtp.gmail.com with ESMTPSA id sb24-20020a170906edd800b009887478cc88sm1154897ejb.177.2023.06.18.11.22.19 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Sun, 18 Jun 2023 11:22:19 -0700 (PDT) Message-ID: <9efb8370-fb32-66b5-5fa0-df61e3b931fc@enterprisedb.com> Date: Sun, 18 Jun 2023 20:22:17 +0200 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.11.1 Subject: Re: Use generation context to speed up tuplesorts To: Ronan Dunklau , pgsql-hackers@lists.postgresql.org Cc: Andres Freund , Tomas Vondra , David Rowley References: <3082578.5fSG56mABF@aivenronan> <94e34870-9e3b-8c49-6617-016253129f06@enterprisedb.com> <2096567.Mh6RI2rZIc@aivenronan> Content-Language: en-US From: Tomas Vondra In-Reply-To: <2096567.Mh6RI2rZIc@aivenronan> Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi Ronan, We briefly chatted about the glibc-tuning part of this thread at pgcon, so I wonder if you're still planning to pursue that. If you do, I suggest we start a fresh thread, so that it's not mixed with the already committed improvements of generation context. I wonder what's the situation with the generation context improvements already pushed - does setting the glibc thresholds still help, and if yes how much? regards -- Tomas Vondra EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company