On Sun, Aug 18, 2019 at 1:57 AM Mariel Cherkassky
<mariel.cherkassky@gmail.com> wrote:
>
> Hey,
> I upgraded my pg9.6 cluster to pg11.2.
> As it seems after the upgrade the duration of the same flow in my application raised from 13 minutes to 19 minutes.
>
> The test I did :
> 1.reset pg_stat_statements
> 2.run the applicative flow
> 3.collect everything from pg_stat_statements
>
> I did this test on the env before the upgrade and after the upgrade. I took the sum of the total_time in
pg_stat_statementsand sumed it up.
Since you have performance data, do you see any trends? For example,
is it generalized performance issues or are there specific queries
that have degraded? We would need more specific detail before being
able to give better advice on how to fix performance issue.
merlin