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 1qB8sP-0004Tz-Iw for pgsql-hackers@arkaria.postgresql.org; Mon, 19 Jun 2023 07:00:37 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1qB8sN-0001vK-QY for pgsql-hackers@arkaria.postgresql.org; Mon, 19 Jun 2023 07:00:35 +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 1qB8sN-0001vA-FU for pgsql-hackers@lists.postgresql.org; Mon, 19 Jun 2023 07:00:35 +0000 Received: from mail-wm1-x32b.google.com ([2a00:1450:4864:20::32b]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qB8sK-003NUj-1s for pgsql-hackers@lists.postgresql.org; Mon, 19 Jun 2023 07:00:34 +0000 Received: by mail-wm1-x32b.google.com with SMTP id 5b1f17b1804b1-3f904dcc1e2so19438035e9.3 for ; Mon, 19 Jun 2023 00:00:31 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aiven.io; s=google; t=1687158031; x=1689750031; h=content-transfer-encoding:mime-version:references:in-reply-to :message-id:date:subject:cc:to:from:from:to:cc:subject:date :message-id:reply-to; bh=NYyR797daiOgDV7xWThiC3fQ4p/1JKzCUr3IeuFKzj0=; b=L60+3A46Xr59Uz1EBMFBvcS0iJVSBIHGlwwLN28BejxWU2kdoPW6hhIE7w9Ce0cOmO UTWFRSv9mLvo73fNhgsihfdz6kTIZwTX74FludpTR6Bsf4ctWZ9FhJS8TgislL5PFeU8 Mm83H28LRDld4dKRATe3OxBxrVZZ+scK3jMAg= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1687158031; x=1689750031; h=content-transfer-encoding:mime-version:references:in-reply-to :message-id:date:subject:cc:to:from:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=NYyR797daiOgDV7xWThiC3fQ4p/1JKzCUr3IeuFKzj0=; b=GvEFXPfvQH9ua+3sYbJ17C5tWCEw79db1fSt0fJN38FnEBp0Lhgc5f2DI+MEKv2hpw d6XbP/z9luWsDj9pY9BDJhTM68NJLZEGPD26WkySLBuytYAbAXkkKXse8k7sm9Tbbdef WtFrgxdvxsWueUgYG/eHnkFM0seqJ5xv0jLIYOKPy2H6A+zYzkVwvhaQhk/IaxPMM/+L P7bN2nE6KeHSNbdcm5sALqNn52CEDhWJkFS+dCaBlYB45/DBjFN8VCCAaDuNSdqZJCJ9 8Hm3HRh4B7XpkcWKi6mtiYGupbeYU4pw75jtYgcMa6MBz9eW9e3+zQ0Hww/z/NMoFs4H NbGg== X-Gm-Message-State: AC+VfDz5Q8MTxru8EwKdgLd3tD51NKJN21z5VBUxUSk9jisDDT1RXxPC oPkVGVR0D4+xrLn7d9+V/yM0nAnbKOxC301d2P1UrHp2uVqKFVHZ813/3tbaTG/VoqDhFmguGSN IrMp1MpBLyEuwhNiyFgIwdc4FpuMujAmQTMWD6Wxo2T7Gufvey5sN7PNQkdiA/2ypgi8oN62o2D aSub24UijHEvozWawWlos= X-Google-Smtp-Source: ACHHUZ5/sKPddUufRbIj9FiKiXB3xwAdRcrjRH4CBueFo5qGqoxLtdUsdKMDWRVWhjNfGVNKSLnQAw== X-Received: by 2002:a5d:480c:0:b0:30a:e5f1:eedd with SMTP id l12-20020a5d480c000000b0030ae5f1eeddmr6794511wrq.67.1687158030752; Mon, 19 Jun 2023 00:00:30 -0700 (PDT) Received: from aivenlaptop.localnet ([45.13.105.93]) by smtp.gmail.com with ESMTPSA id i1-20020adffc01000000b0030aee3da084sm30506899wrr.49.2023.06.19.00.00.30 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 19 Jun 2023 00:00:30 -0700 (PDT) From: Ronan Dunklau To: pgsql-hackers@lists.postgresql.org, Tomas Vondra Cc: Andres Freund , Tomas Vondra , David Rowley Subject: Re: Use generation context to speed up tuplesorts Date: Mon, 19 Jun 2023 09:01:56 +0200 Message-ID: <5942566.lOV4Wx5bFT@aivenlaptop> In-Reply-To: <9efb8370-fb32-66b5-5fa0-df61e3b931fc@enterprisedb.com> References: <2096567.Mh6RI2rZIc@aivenronan> <9efb8370-fb32-66b5-5fa0-df61e3b931fc@enterprisedb.com> MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset="iso-8859-1" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Le dimanche 18 juin 2023, 20:22:17 CEST Tomas Vondra a =E9crit : > Hi Ronan, >=20 > 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. >=20 > 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? Hi Tomas !=20 I'm currently working on it, trying to evaluate the possible benefits on th= e=20 current ASet and Generation contexts usecases.=20 I'll make sure to use a new thread to post my findings. Thank you for remembering ! Best regards, =2D- Ronan Dunklau