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 1rz1SI-001YJ7-6d for pgsql-general@arkaria.postgresql.org; Mon, 22 Apr 2024 21:44:06 +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 1rz1SG-000CgT-Oe for pgsql-general@arkaria.postgresql.org; Mon, 22 Apr 2024 21:44:04 +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 1rz1SG-000Cg6-DB for pgsql-general@lists.postgresql.org; Mon, 22 Apr 2024 21:44:04 +0000 Received: from mail-lj1-x232.google.com ([2a00:1450:4864:20::232]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1rz1SD-0049TP-TX for pgsql-general@lists.postgresql.org; Mon, 22 Apr 2024 21:44:03 +0000 Received: by mail-lj1-x232.google.com with SMTP id 38308e7fff4ca-2d895e2c6efso74789901fa.0 for ; Mon, 22 Apr 2024 14:44:01 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1713822239; x=1714427039; darn=lists.postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=iMK4RW5z+EqwrUDGFtU+/SKPdRO4y2cwWV7dEG3Cda8=; b=JUp7Vf4RrWZ/9MrCwE4J2pcdV9jaM6P7Xvq98yn7xtQJ+NhLi+1J/FLeETr0aKuzvk qh4wuOI2e2sbHc5vyLN6+vbPr1q8qfsCBcEHhISuiVusW9Mch5j+Q3EVP7tVWBoI3FYl BuUirUbd8fBoJKNvotTCILBZEG1AQzrtL9jMqbId97LKSvDV0m2DbmdYV/A4N8vfbFti P9+Ixqv2KCoICfWRiqgn/TeEfc97aigOXyxdmpmZqDk+ZGI20bFaJcACQkf9cS6lIVJw LtcwrhW2/nZy6Wx8obVIeJQ6VT3lH902DJnnNgUfcxbB9JM2r8dQ4xb5jfUVmi5P2ruk kDdg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1713822239; x=1714427039; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=iMK4RW5z+EqwrUDGFtU+/SKPdRO4y2cwWV7dEG3Cda8=; b=ZonLfOA85F29xA2B6HHJdfvRbaLSv9QXkuPtyRHq+DmlPNWppc/5F4Yx76InRg3XF4 v/y0/1EUHopHKnrUfb/YDaEq5WKaBdp2cMZmZ87Iknpr0oU2BqrBj8oqc1aUag7O3jQX cxuvx0qie7HWZ3po/rlGH4pcioKtc0Sc5ANnRcVOpouHM02puyjpytf5nuiqWPjBlD+L aQ0oc+OF+fTe4Ahogo6f7w3XxPtqSzxWEj183wJkiJ0C1gRI8qyMC4nJyP6wfZfxx2DP IQIsn27+t5Hs1/BAcWoJyIB/+tq3EF6FnnGowlsq1g22t0/2e0wTZFYUDnlGV0bqoyVm dcjQ== X-Forwarded-Encrypted: i=1; AJvYcCW+DKPawbVcvfNmRFUy54cjMr/RzCIphrqMynAqpk/RDsP7invDDniiZzBgPoc/Orli9IzLZ8cbN32tPsvR0L8HdrvXmTc/u3D/JLQVcQZ6zVbw X-Gm-Message-State: AOJu0YxrToGxSASk/jevhdDvMFMMD6V5P1ZkUQy+GAnoupx4fzJfKe3Z U3/sA+j51SqNc0AHg+mZ8iQUsuj3c0wqzjIb+wpDaZP4N8le6UtjCLRd6vVZx67G+XeWOtbfE9F 1R5vVO0KdjJ3KjbHVih4LKEi8omA= X-Google-Smtp-Source: AGHT+IH6ri0DcOB4jTnbvofvamER7LVvKOmNfuQMYyrnc33tA+0+FWSw9ps2Xj6ewgcKLR2JdUCvVFSqgCl8Ea6apoA= X-Received: by 2002:a2e:b170:0:b0:2dd:c2fb:4ed9 with SMTP id a16-20020a2eb170000000b002ddc2fb4ed9mr1614836ljm.35.1713822238930; Mon, 22 Apr 2024 14:43:58 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: David Rowley Date: Tue, 23 Apr 2024 09:43:47 +1200 Message-ID: Subject: Re: Performance degradation after upgrading from 9.5 to 14 To: =?UTF-8?B?0J7Qu9C10LrRgdCw0L3QtNGAINCv0L3RltC9?= Cc: Johnathan Tiamoh , "pgsql-generallists.postgresql.org" Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Tue, 23 Apr 2024 at 07:01, =D0=9E=D0=BB=D0=B5=D0=BA=D1=81=D0=B0=D0=BD=D0= =B4=D1=80 =D0=AF=D0=BD=D1=96=D0=BD wrote: > Try setting enable_memoize to off. > Our practice has shown that enabling this parameter by default often resu= lted in less than optimal query plans in the cache. It would be good to see a thread opened with details on this. I understand incorrect statistics can cause this but if there are other reasons, it would be good to know what they are. David