From: | Marcin Giedz <marcin(dot)giedz(at)arise(dot)pl> |
---|---|
To: | Johnathan Tiamoh <johnathantiamoh(at)gmail(dot)com> |
Cc: | Tomas Vondra <tomas(dot)vondra(at)enterprisedb(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:38:57 |
Message-ID: | CAEJ6yN3CghLmJ5fhGCLRM3zw6qRjmffk+M-CJxOboTyvT4X0qw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
how about this:
jit = off ?
Marcin
On Wed, 17 Apr 2024 at 19:33, Johnathan Tiamoh <johnathantiamoh(at)gmail(dot)com>
wrote:
> 1) How did you upgrade? pg_dump or pg_upgrade?
>
> I use pg_ugrade with kink option.
>
> 2) Did you run ANALYZE to collect statistics after the upgrade?
>
>
> Yes. I ran vacuumdb-analyze in stages after the upgrade
>
> 3) Did you transfer the configuration, or did you just create a new
> cluster with the default values?
>
> I transfer the configuration
>
> 4) What exactly is slower? Queries? Inserts?
>
> queries
>
> 5) Can you quantify the impact? Is it 2x slower? 100x slower?
>
> it's more than 5 times slower than before. Very high load averages
>
> On Wed, Apr 17, 2024 at 1:25 PM Tomas Vondra <
> tomas(dot)vondra(at)enterprisedb(dot)com> wrote:
>
>> 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 | Justin | 2024-04-17 19:17:10 | Re: replication slot "pg_1015733_sync_1014718_7358407382484881476" does not exist |
Previous Message | Johnathan Tiamoh | 2024-04-17 17:32:49 | Re: Performance degradation after upgrading from 9.5 to 14 |