| From: | Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com> |
|---|---|
| To: | Johnathan Tiamoh <johnathantiamoh(at)gmail(dot)com>, "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:25:25 |
| Message-ID: | 72c40850-1dc6-41a9-ba90-e19328999ea8@enterprisedb.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 4/17/24 19:13, Johnathan Tiamoh wrote:
> 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 ?
>
There's very little practical advice we can provide based on this
report, because it's missing any useful details. There's a number of
things that might have caused this, but we'd have to speculate.
For example:
1) How did you upgrade? pg_dump or pg_upgrade?
2) Did you run ANALYZE to collect statistics after the upgrade?
3) Did you transfer the configuration, or did you just create a new
cluster with the default values?
4) What exactly is slower? Queries? Inserts?
5) Can you quantify the impact? Is it 2x slower? 100x slower?
regards
--
Tomas Vondra
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christophe Pettus | 2024-04-17 17:28:48 | Re: Performance degradation after upgrading from 9.5 to 14 |
| Previous Message | Johnathan Tiamoh | 2024-04-17 17:13:09 | Performance degradation after upgrading from 9.5 to 14 |