public inbox for [email protected]
help / color / mirror / Atom feedFrom: kaido vaikla <[email protected]>
To: Marcin Giedz <[email protected]>
Cc: Johnathan Tiamoh <[email protected]>
Cc: Tomas Vondra <[email protected]>
Cc: pgsql-generallists.postgresql.org <[email protected]>
Subject: Re: Performance degradation after upgrading from 9.5 to 14
Date: Sat, 20 Apr 2024 10:59:02 +0300
Message-ID: <CA+427g8YgWMYOO-Cow7pbDYc3=d5e-MqJSMnqub+v+AXTRtscA@mail.gmail.com> (raw)
In-Reply-To: <CAEJ6yN3CghLmJ5fhGCLRM3zw6qRjmffk+M-CJxOboTyvT4X0qw@mail.gmail.com>
References: <CACoPQdb02ePEEdxGifTWWypke10tao_tKBmwi+7tu7KVkPdDuA@mail.gmail.com>
<[email protected]>
<CACoPQdZ1AfRQoAf=Zw+H-bffR_g4m3vV4=O+p64b--_cqKS_-g@mail.gmail.com>
<CAEJ6yN3CghLmJ5fhGCLRM3zw6qRjmffk+M-CJxOboTyvT4X0qw@mail.gmail.com>
I'm not sure, does it helps you but read this:
https://www.cybertec-postgresql.com/en/b-tree-index-improvements-in-postgresql-v12/
"Since upgrading with pg_upgrade does not change the data files, indexes
will still be in version 3 after an upgrade"
I reindexed all my database, when did upgrade pg<12 -> pg>=12 if pg_upgrade
was a tool. exp-imp for upgrade does not need reindex.
br
Kaido
On Wed, 17 Apr 2024 at 20:39, Marcin Giedz <[email protected]> wrote:
> how about this:
>
> jit = off ?
>
> Marcin
>
>
> On Wed, 17 Apr 2024 at 19:33, Johnathan Tiamoh <[email protected]>
> 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 <
>> [email protected]> 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
>>>
>>
view thread (9+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected], [email protected]
Subject: Re: Performance degradation after upgrading from 9.5 to 14
In-Reply-To: <CA+427g8YgWMYOO-Cow7pbDYc3=d5e-MqJSMnqub+v+AXTRtscA@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox