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 1rx8qY-006c2x-W8 for pgsql-general@arkaria.postgresql.org; Wed, 17 Apr 2024 17:13:22 +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 1rx8qX-00D8ND-M3 for pgsql-general@arkaria.postgresql.org; Wed, 17 Apr 2024 17:13:21 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rx8qX-00D8N4-Aw for pgsql-general@lists.postgresql.org; Wed, 17 Apr 2024 17:13:21 +0000 Received: from mail-lj1-x22e.google.com ([2a00:1450:4864:20::22e]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1rx8qV-001UQ1-3h for pgsql-general@lists.postgresql.org; Wed, 17 Apr 2024 17:13:20 +0000 Received: by mail-lj1-x22e.google.com with SMTP id 38308e7fff4ca-2da01cb187cso103793601fa.0 for ; Wed, 17 Apr 2024 10:13:19 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1713373997; x=1713978797; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=0oVX9qwlPa2LWXJBoYK78HDYrHG0ngxxDwvfpqiWOug=; b=FHuMV3prV9C7OSNpbBn0BOnbZvJHi7cviH+AsYJUuXS572FAVL3CX1WxFxEeZs+8H0 rZ4sPtJ8WruYINH5PcHVw7JzhbG2SSzY0Km16tzrPSkhLUYfQeVUZpIrLj9l+6D3JEQf Kg0JxsrbssWL0ce4XyhaJRj34feFtsuz0A7LEG46FleUflU+Cf1FHzcxMW9j/MEvFvGD QnZJhhF1C4/X3to1JLNMJdONbxehDyltstUXMnnonTXB3gR9a2YTN4XnslbRuKXWiFXP J7W7RWxDEXU0fDiLEuP6kDR9XRMUuuahXp6G0XBP3enYlEvAzf/xopl/C3KHFVbUpf64 +rWQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1713373997; x=1713978797; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=0oVX9qwlPa2LWXJBoYK78HDYrHG0ngxxDwvfpqiWOug=; b=Pz+dzk13+v4pWJEtbPmqI5NNEFjf8w23ZXOQKs7yqT9SKrTiunPkkyBw5gF+c65TVK EkVZTt/zi/+6pM5afLzIq+XpYjZEcoD1J6g2rPJIfikrFX0X9do5lGnC2l+Nn18AUx6g uYrcLgKIGJBZRG6WZR6xc9Y2TzaY6ZSany2tYZyulYFwLDy25TxSN1NvQn55EgHv67mX /65qtPAPqUmosmrmo1azLULQJuSNb8QU7Vs2ct10eL0UFmcwrJD4w54UeRVA/eQnOqMI /FpAl7yroRmMFpBZZDs5wAvpW8++Qs8XfLLHqFIW6vgbuXIAYDa9cpfqoUxntKnEI43s YXFQ== X-Gm-Message-State: AOJu0YwE16bBY4mirIKt4tY4LoBqW2eeI8DtVtyTehY6Jaew3L42wt9Z rbKaCN1KO269TZE+/FAQH7FVG0moDCV3dyGfWhgS/1sYnQElsjHX3EBYaTrJeVJwm4fXreNOLMc 20QqRlysrbJXvkBZR7AelLnmurhr9sw== X-Google-Smtp-Source: AGHT+IH7CBGBiimJtbTzTBUn/g42Nfskw7BnUCYsa95zWl9aKLedXrSbrhhtc+0EBjO/KzeEEOVd5udMDvSiydYHXzA= X-Received: by 2002:a2e:9ed4:0:b0:2d9:fd90:af57 with SMTP id h20-20020a2e9ed4000000b002d9fd90af57mr11971241ljk.51.1713373997280; Wed, 17 Apr 2024 10:13:17 -0700 (PDT) MIME-Version: 1.0 From: Johnathan Tiamoh Date: Wed, 17 Apr 2024 13:13:09 -0400 Message-ID: Subject: Performance degradation after upgrading from 9.5 to 14 To: "pgsql-generallists.postgresql.org" Content-Type: multipart/alternative; boundary="00000000000079b7c106164df8fe" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000079b7c106164df8fe Content-Type: text/plain; charset="UTF-8" Hello, I performed an upgrade from postgresql-9.5 to postgresql-14 and the performance has degraded drastically. Please, is they any advice on getting performance back ? King Regards Johnathan T. --00000000000079b7c106164df8fe Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hello,


I performed an=C2= =A0 upgrade from postgresql-9.5 to postgresql-14 and the performance has de= graded drastically.

Please, is they any advice on = getting performance back ?


King=C2= =A0Regards
Johnathan T.


<= br>
--00000000000079b7c106164df8fe--