Content-Type: text/plain;
	charset=us-ascii
Mime-Version: 1.0 (Mac OS X Mail 13.4 \(3608.120.23.2.7\))
Subject: Re: Performance degradation after upgrading from 9.5 to 14
From: Christophe Pettus <xof@thebuild.com>
In-Reply-To: <CACoPQdb02ePEEdxGifTWWypke10tao_tKBmwi+7tu7KVkPdDuA@mail.gmail.com>
Date: Wed, 17 Apr 2024 10:28:48 -0700
Cc: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Transfer-Encoding: quoted-printable
Message-Id: <36ABD763-8D40-465B-8013-3C50712259E3@thebuild.com>
References: <CACoPQdb02ePEEdxGifTWWypke10tao_tKBmwi+7tu7KVkPdDuA@mail.gmail.com>
To: Johnathan Tiamoh <johnathantiamoh@gmail.com>
Archived-At: <https://www.postgresql.org/message-id/36ABD763-8D40-465B-8013-3C50712259E3%40thebuild.com>
Precedence: bulk


> On Apr 17, 2024, at 10:13, Johnathan Tiamoh =
<johnathantiamoh@gmail.com> wrote:
> I performed an  upgrade from postgresql-9.5 to postgresql-14 and the =
performance has degraded drastically.
>=20
> Please, is they any advice on getting performance back ?

Run:

	VACUUM (ANALYZE, VERBOSE);

More seriously (although make sure you did do that), "performance" is =
made up of a lot of components.  There's no "go faster" switch in =
postgresql.conf you may have neglected.  You'll need to do a bit of =
investigation first to find out what is running slow, where it should be =
fast: I/O performance?  Query times?  Once you have that information, =
the community can provide much more assistance.=