RE: Memory issues with PostgreSQL 15

2024-07-25 Thread Christian Schröder
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

RE: Memory issues with PostgreSQL 15

2024-05-30 Thread Christian Schröder
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

RE: Memory issues with PostgreSQL 15

2024-05-30 Thread Christian Schröder
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

RE: Memory issues with PostgreSQL 15

2024-05-29 Thread Christian Schröder
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>

Memory issues with PostgreSQL 15

2024-05-28 Thread Christian Schröder
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

RE: Performance issue after migration from 9.4 to 15

2023-04-12 Thread Christian Schröder
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

RE: Performance issue after migration from 9.4 to 15

2023-04-12 Thread Christian Schröder
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

Performance issue after migration from 9.4 to 15

2023-04-11 Thread Christian Schröder
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