Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rQTFH-001UMH-1E for pgsql-hackers@arkaria.postgresql.org; Thu, 18 Jan 2024 14:19:52 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rQTEI-002vYB-1d for pgsql-hackers@arkaria.postgresql.org; Thu, 18 Jan 2024 14:18:50 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rQTEH-002vWW-KH for pgsql-hackers@lists.postgresql.org; Thu, 18 Jan 2024 14:18:49 +0000 Received: from mail.postgrespro.ru ([93.174.131.139]) by makus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rQTED-002A95-77 for pgsql-hackers@lists.postgresql.org; Thu, 18 Jan 2024 14:18:47 +0000 Received: from [192.168.1.35] (cm-27-145-161-7.revip12.asianet.co.th [27.145.161.7]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (Client did not present a certificate) (Authenticated sender: a.lepikhov@postgrespro.ru) by mail.postgrespro.ru (Postfix/587) with ESMTPSA id 54448E210A3; Thu, 18 Jan 2024 17:18:38 +0300 (MSK) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=postgrespro.ru; s=mx2023; t=1705587521; bh=Zl/LJ3YIgMblYdibXI3OHBpvDzKe26afS6kGsXyW/iI=; h=Message-ID:Date:User-Agent:Subject:From:To:Cc:References: In-Reply-To:From; b=M1pZHdqqgcySP18Ak6wBlFQCL8ao7g0f2anzZ/zPO2x+JGJOGpXr8CM8HY/58g1JW oLeC391+Z8nwo+MS8nCGVmNhSk06J8KHkTdkg3byqFGLI+E7R60eZFKNL9Po8Kmynu UhwHD5jzSa2IuuSGNRKAE0zqLSn724W3NRNEwDH2NKBYz5dyNryoviYMvdawv9tZTM DiZqXDZsrIIDiy7LVrjIEM0+kl+0mh7C4SoquiGV+LRfCltnxsa1TIYxxaQ8RFiZsu mYLc3occkY1QkrRcXCeC/qbBqHo0AMwK/m7xFJD94CPrs1WOAxS1YfSnNpRui9uvUD FisagrjOA5yqA== Content-Type: multipart/mixed; boundary="------------QrAkdeL7zd0MNfy89KJTbKHV" Message-ID: Date: Thu, 18 Jan 2024 21:18:34 +0700 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: POC: GROUP BY optimization From: Andrei Lepikhov To: Alexander Korotkov , Richard Guo Cc: Pavel Borisov , vignesh C , PostgreSQL Developers , Tomas Vondra , Teodor Sigaev , David Rowley , "a.rybakina" , Tom Lane References: <138cb2df-1a0d-48c0-be80-48aaf62e8aeb@postgrespro.ru> Content-Language: en-US Organization: Postgres Professional In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------QrAkdeL7zd0MNfy89KJTbKHV Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit Just forgotten second attachment. -- regards, Andrei Lepikhov Postgres Professional --------------QrAkdeL7zd0MNfy89KJTbKHV Content-Type: text/plain; charset=UTF-8; name="step2.txt" Content-Disposition: attachment; filename="step2.txt" Content-Transfer-Encoding: base64 ZGlmZiAtLWdpdCBhL3NyYy9iYWNrZW5kL29wdGltaXplci9wYXRoL3BhdGhrZXlzLmMgYi9z cmMvYmFja2VuZC9vcHRpbWl6ZXIvcGF0aC9wYXRoa2V5cy5jCmluZGV4IDEwOTViNzNkYWMu LmI2MTI0MjA1NDcgMTAwNjQ0Ci0tLSBhL3NyYy9iYWNrZW5kL29wdGltaXplci9wYXRoL3Bh dGhrZXlzLmMKKysrIGIvc3JjL2JhY2tlbmQvb3B0aW1pemVyL3BhdGgvcGF0aGtleXMuYwpA QCAtNDMyLDYgKzQzMiwyMSBAQCBncm91cF9rZXlzX3Jlb3JkZXJfYnlfcGF0aGtleXMoTGlz dCAqcGF0aGtleXMsIExpc3QgKipncm91cF9wYXRoa2V5cywKIAlyZXR1cm4gbjsKIH0KIAor c3RhdGljIGJvb2wKK2R1cGxpY2F0ZWRfcGF0aGtleV9jb21iaW5hdGlvbihMaXN0ICppbmZv cywgTGlzdCAqcGF0aGtleXMpCit7CisJTGlzdENlbGwgKmxjOworCisJZm9yZWFjaCAobGMs IGluZm9zKQorCXsKKwkJUGF0aEtleUluZm8gKmluZm8gPSBsZmlyc3Rfbm9kZShQYXRoS2V5 SW5mbywgbGMpOworCisJCWlmIChjb21wYXJlX3BhdGhrZXlzKHBhdGhrZXlzLCBpbmZvLT5w YXRoa2V5cykgPT0gUEFUSEtFWVNfRVFVQUwpCisJCQlyZXR1cm4gdHJ1ZTsKKwl9CisJcmV0 dXJuIGZhbHNlOworfQorCiAvKgogICogZ2V0X3VzZWZ1bF9ncm91cF9rZXlzX29yZGVyaW5n cwogICoJCURldGVybWluZSB3aGljaCBvcmRlcmluZ3Mgb2YgR1JPVVAgQlkga2V5cyBhcmUg cG90ZW50aWFsbHkgaW50ZXJlc3RpbmcuCkBAIC00OTEsNyArNTA2LDcgQEAgZ2V0X3VzZWZ1 bF9ncm91cF9rZXlzX29yZGVyaW5ncyhQbGFubmVySW5mbyAqcm9vdCwgUGF0aCAqcGF0aCkK IAogCQlpZiAobiA+IDAgJiYKIAkJCShlbmFibGVfaW5jcmVtZW50YWxfc29ydCB8fCBuID09 IHJvb3QtPm51bV9ncm91cGJ5X3BhdGhrZXlzKSAmJgotCQkJY29tcGFyZV9wYXRoa2V5cyhw YXRoa2V5cywgcm9vdC0+Z3JvdXBfcGF0aGtleXMpICE9IFBBVEhLRVlTX0VRVUFMKQorCQkJ IWR1cGxpY2F0ZWRfcGF0aGtleV9jb21iaW5hdGlvbihpbmZvcywgcGF0aGtleXMpKQogCQl7 CiAJCQlpbmZvID0gbWFrZU5vZGUoUGF0aEtleUluZm8pOwogCQkJaW5mby0+cGF0aGtleXMg PSBwYXRoa2V5czsKQEAgLTUxNCw4ICs1MjksOSBAQCBnZXRfdXNlZnVsX2dyb3VwX2tleXNf b3JkZXJpbmdzKFBsYW5uZXJJbmZvICpyb290LCBQYXRoICpwYXRoKQogCQkJCQkJCQkJCSAg ICZjbGF1c2VzLAogCQkJCQkJCQkJCSAgIHJvb3QtPm51bV9ncm91cGJ5X3BhdGhrZXlzKTsK IAotCQlpZiAobiA+IDAgJiYgY29tcGFyZV9wYXRoa2V5cyhwYXRoa2V5cywgcm9vdC0+Z3Jv dXBfcGF0aGtleXMpICE9IFBBVEhLRVlTX0VRVUFMICYmCi0JCQkoZW5hYmxlX2luY3JlbWVu dGFsX3NvcnQgfHwgbiA9PSBsaXN0X2xlbmd0aChyb290LT5zb3J0X3BhdGhrZXlzKSkpCisJ CWlmIChuID4gMCAmJgorCQkJKGVuYWJsZV9pbmNyZW1lbnRhbF9zb3J0IHx8IG4gPT0gbGlz dF9sZW5ndGgocm9vdC0+c29ydF9wYXRoa2V5cykpICYmCisJCQkhZHVwbGljYXRlZF9wYXRo a2V5X2NvbWJpbmF0aW9uKGluZm9zLCBwYXRoa2V5cykpCiAJCXsKIAkJCWluZm8gPSBtYWtl Tm9kZShQYXRoS2V5SW5mbyk7CiAJCQlpbmZvLT5wYXRoa2V5cyA9IHBhdGhrZXlzOwo= --------------QrAkdeL7zd0MNfy89KJTbKHV--