On 4/11/23 07:41, Christian Schröder wrote:
Hi all,
Thanks for all your tips!
I have meanwhile run "ANALYZE" on all tables. Either that was as important as everybody tells me 😉 or it is just a coincidence (e.g., fewer other queries on the database).
It is:
https://www.postgresql.org/docs/curr
they
should not affect the performance of a single sequential scan.
Best,
Christian
From: Inzamam Shafiq
Sent: Tuesday, April 11, 2023 1:25 PM
To: Christian Schröder
Subject: Re: Performance issue after migration from 9.4 to 15
Hi,
How did you upgrade the databse? if it is done by
PM
To: David Rowley
Cc: Christian Schröder ;
pgsql-general@lists.postgresql.org
Subject: Re: Performance issue after migration from 9.4 to 15
David Rowley writes:
> On Tue, 11 Apr 2023 at 23:03, Christian Schröder
> wrote:
>> Particularly interesting are the sequential scans. In th
David Rowley writes:
> On Tue, 11 Apr 2023 at 23:03, Christian Schröder
> wrote:
>> Particularly interesting are the sequential scans. In the old plan, we have
>> node #21, which took 32 seconds. Almost all of the time goes into actual
>> I/O. In the new plan, the corresponding node is #34. It
On Tue, 11 Apr 2023 at 23:03, Christian Schröder
wrote:
> We have recently migrated from our old PostgreSQL 9.4 server to a PostgreSQL
> 15 server. Even though the new machine has more resources, we see a
> considerable decrease in the performance of some of our heavier queries, and
> I have no
