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 1mUst2-0001hl-My for pgsql-performance@arkaria.postgresql.org; Mon, 27 Sep 2021 15:49:48 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mUst0-0006qh-3c for pgsql-performance@arkaria.postgresql.org; Mon, 27 Sep 2021 15:49:46 +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 1mUssz-0006qY-D1 for pgsql-performance@lists.postgresql.org; Mon, 27 Sep 2021 15:49:45 +0000 Received: from mail-pj1-x1035.google.com ([2607:f8b0:4864:20::1035]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1mUssr-0000fG-TC for pgsql-performance@postgresql.org; Mon, 27 Sep 2021 15:49:43 +0000 Received: by mail-pj1-x1035.google.com with SMTP id d4-20020a17090ad98400b0019ece228690so4031560pjv.5 for ; Mon, 27 Sep 2021 08:49:37 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb.com; s=google; h=subject:to:cc:references:from:message-id:date:user-agent :mime-version:in-reply-to:content-language; bh=ryZa8O4Nq0JstRG8tynS2NwVSQtYndqfIArDMcRfghE=; b=DG+tCxXqgNF2sy3C1glpdYG0Gt0R0yCdmR33M0FetNpmRwLplKaKD5VxhoROxRBFfm A0aO75lVjKtNpI6Z2UkJ2kGzdV+F+RV7Vr46LAtVaLmWLYxckDEb1qF/S0KdEV9IFW/p ZKx/z6pnzl5WGc0Iq6Mu/eBdBWHO4Flz9ShL2yAFx0VEs8QvXjs0T2dDFPj9IX0bDNZG HyG4E4z+Q+aWzDaxXnvidfVWHAiu1gmKm6zFy1hyFtywHZy7rpSiMVSyheerC43VmDYn +Tw6ecB5lZNCO2D2xj/TOAfbSO9Xge7ljY5kHtIqGLCrgdzGHlIcbFfKMgOk7lgo1vex M02w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:subject:to:cc:references:from:message-id:date :user-agent:mime-version:in-reply-to:content-language; bh=ryZa8O4Nq0JstRG8tynS2NwVSQtYndqfIArDMcRfghE=; b=QqCBya9VOEYKX/qSu7TH4F3wo8iIwRB41JBosJRWcZK5lXJbtGo7u1bDcJXlKZVCGD ZYhVHvozTmAbISUxmBDKiEVywfC/oSFkC7/2Y1U7zY60x1uYO1xPyyoIWJs4zMqjTW5F ir8VMXbY0qU+V5TU3d5Qyr9bnDolAne0Pf2CtS2fPDzd1DDiCCZJBYmbGE93ePlju+qm 48GAvuL4fbfXtsjIVy217GURUV+CXnTx6LAS3f+6SNoFRsrfhpx0MPQrtscUdWAv369p Ws65oCq5ZU3GYg4jwv2c+LysTTQj2psPu3eC1blCwlbeFXJgb+JcNF6zeei0JjBu4Pf9 q7CQ== X-Gm-Message-State: AOAM530ci/l58eJ+lrww4HcyOR64Jr5fQOgq4fmrI3Mg3y2MbbeenN2n Y5sfpQapkMZ5NWOCQDDtgMrhNi0yYR3dYRAej+M3XOqn9e95X4l6ESXnsGinn1Ha8/oUPX8pWp9 rF40PmJFwbM0YB7TrYZJuYWiP7xJY9XuPRkOXrt7SD3ix/vWpyVfy7BElR4G6chKRlmIhP2lr+U fnQANB49gp+VKhlHDW0gsaboHcL/SihshdKIaM2VzaD0s4RAKIKgFWcmXgnsudtLx8Wt2eOxh0i oonz8lR4kvNLo7vXoOG15Rp59P+j11jtra1WOCv6bJ+Z6AR X-Google-Smtp-Source: ABdhPJx6Mmmf481QPVGml2HKKKB3xM12iHCyiLA+T28/1bvuxyoTbugG0nc+lXuwi5nn4CuRfabwGw== X-Received: by 2002:a17:90b:38cf:: with SMTP id nn15mr20783219pjb.81.1632757775851; Mon, 27 Sep 2021 08:49:35 -0700 (PDT) Received: from localhost.localdomain ([45.113.251.168]) by smtp.gmail.com with ESMTPSA id h13sm18859262pgf.14.2021.09.27.08.49.32 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Mon, 27 Sep 2021 08:49:35 -0700 (PDT) Subject: Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 To: Andrew Dunstan , "ldh@laurent-hasson.com" , Julien Rouhaud Cc: Tom Lane , Ranier Vilela , Justin Pryzby , "pgsql-performance@postgresql.org" References: <6c68ee84-a4b7-7935-3804-49c6d69a0052@dunslane.net> <8276415b-5932-884f-e53f-13a3746a3a69@dunslane.net> <7ff352d4-4879-5181-eb89-8a2046f928e6@dunslane.net> <7a8b56a4-18d9-60f2-40f1-910c0b1337e4@dunslane.net> <9bc5f1df-e847-29a4-a907-7a5d643b7d0d@dunslane.net> <356aa553-801b-92d2-5615-8b930d049436@dunslane.net> From: tushar Message-ID: <85085d09-fe5e-34ca-fe08-bc891f687556@enterprisedb.com> Date: Mon, 27 Sep 2021 21:19:31 +0530 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101 Thunderbird/60.9.0 MIME-Version: 1.0 In-Reply-To: <356aa553-801b-92d2-5615-8b930d049436@dunslane.net> Content-Type: multipart/alternative; boundary="------------DF6CCCF06788C6C1B75DAD69" Content-Language: en-US X-CLOUD-SEC-AV-Info: enterprisedb,google_mail,monitor X-CLOUD-SEC-AV-Sent: true X-Gm-Spam: 0 X-Gm-Phishy: 0 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. --------------DF6CCCF06788C6C1B75DAD69 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit On 9/27/21 6:55 PM, Andrew Dunstan wrote: >> Hello Andrew, >> >> I just download the 13.4 Windows x86-64 installer fromhttps://www.enterprisedb.com/downloads/postgres-postgresql-downloads but it's the exact same file bit for bit from the previous version I had. Am I looking at the wrong place? >> > Thanks. We're dealing with that. However, you can update that version > via stackbuilder. It will show you that 13.4.2 is available. This has > the correct libintl DLL. I just did this to verify it. Thanks, look like the issue is fixed now, you can try to download the 'postgresql-13.4-2-windows-x64.exe' installer from the above mentioned link. -- regards,tushar EnterpriseDB https://www.enterprisedb.com/ The Enterprise PostgreSQL Company --------------DF6CCCF06788C6C1B75DAD69 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 7bit
On 9/27/21 6:55 PM, Andrew Dunstan wrote:
Hello Andrew,

I just download the 13.4 Windows x86-64 installer from https://www.enterprisedb.com/downloads/postgres-postgresql-downloads but it's the exact same file bit for bit from the previous version I had. Am I looking at the wrong place?


Thanks. We're dealing with that. However, you can update that version
via stackbuilder. It will show you that 13.4.2 is available. This has
the correct libintl DLL. I just did this to verify it.

Thanks, look like the issue is fixed now, you can try to download the 'postgresql-13.4-2-windows-x64.exe' installer from the above mentioned link.

-- 
regards,tushar
EnterpriseDB  https://www.enterprisedb.com/
The Enterprise PostgreSQL Company
--------------DF6CCCF06788C6C1B75DAD69--