| From: | Christophe Pettus <xof(at)thebuild(dot)com> |
|---|---|
| To: | Johnathan Tiamoh <johnathantiamoh(at)gmail(dot)com> |
| Cc: | "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Performance degradation after upgrading from 9.5 to 14 |
| Date: | 2024-04-17 17:28:48 |
| Message-ID: | 36ABD763-8D40-465B-8013-3C50712259E3@thebuild.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> On Apr 17, 2024, at 10:13, Johnathan Tiamoh <johnathantiamoh(at)gmail(dot)com> wrote:
> 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 ?
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Johnathan Tiamoh | 2024-04-17 17:32:49 | Re: Performance degradation after upgrading from 9.5 to 14 |
| Previous Message | Tomas Vondra | 2024-04-17 17:25:25 | Re: Performance degradation after upgrading from 9.5 to 14 |