ving this old thread.
Best,
Christian
PS: The database does not run in a Docker container.
-Original Message-
From: Tom Lane
Sent: Wednesday, May 29, 2024 11:44 PM
To: Christian Schröder
Cc: Francisco Olarte ;
pgsql-general@lists.postgresql.org; Eric Wong
Subject: Re: Memory issues with Postg
kernel.shmmax = 18446744073692774399
kernel.shmmni = 4096
Thanks,
Christian
From: Muhammad Salahuddin Manzoor
Sent: Wednesday, May 29, 2024 11:41 AM
To: Christian Schröder
Cc: pgsql-general ; Eric Wong
Subject: Re: Memory issues with PostgreSQL 15
[EXTERNAL]
Greetings,
The error message you
Hi Francisco,
Unfortunately, all disks have plenty of free space, so this can be ruled out as
a reason.
I will follow up on the other suggestions from the list.
Best,
Christian
-Original Message-
From: Francisco Olarte
Sent: Wednesday, May 29, 2024 10:24 AM
To: Christian Schröder
Cc
Sent: Tuesday, May 28, 2024 7:15 PM
To: Christian Schröder
Cc: pgsql-general@lists.postgresql.org; Eric Wong
Subject: Re: Memory issues with PostgreSQL 15
[EXTERNAL]
Hi Christian:
On Tue, 28 May 2024 at 18:40, Christian Schröder
wrote:
> <2024-05-21 11:34:46 CEST - mailprocessor>
Hi all,
We migrated from PostgreSQL 9.4 to PostgreSQL 15 a while ago. Since then, we
have a lot of memory issues in our QA environment (which is a bit tense in
resources). We did not have these problems before the migration, and we do not
have them in our production environment, which has a lot
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
Hi list,
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 idea
where I should start tuning. ?
Old database: Post