public inbox for [email protected]  

help / color / mirror / Atom feed

From: [email protected]
To: [email protected]
Subject: Re: Running docker in postgres, SHM size of the docker container in postgres 16
Date: Wed, 20 Nov 2024 14:06:30 +0000 (UTC)
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAGbX52HN8FRkmN6zfAnevFRLw058B59mAEJbghLXeXcK_HZd+g@mail.gmail.com>
References: <CAGbX52GNvsV-sNAS36LwmFOc2Qsn74ZA31T_GNJNeBYATJGBAw@mail.gmail.com>
	<CA+hUKGKKUoS4PDjjP_j6tHRS7jPm=Pu+4Ai56ZT+UWoT2FRcoQ@mail.gmail.com>
	<CAGbX52HN8FRkmN6zfAnevFRLw058B59mAEJbghLXeXcK_HZd+g@mail.gmail.com>

Docker databases do not perform well under heavy load.
Everything can be configured to improve performance but going through the Docker disk access layer will significantly decrease performance.

 On Wednesday, November 20, 2024 at 06:06:36 AM GMT-5, Koen De Groote <[email protected]> wrote:

 That explains a lot.
I have the default of 2 max_parallel_maintenance_workers set, should I set this to 0?
I realize this is of course an improvement, but working with docker containers, I'd like to avoid taking /dev/shm away from regular queries.
I assume setting max_parallel_maintenance_workers to 0 is the fix here, is there perhaps something else I should know about, if I want to have control over this?
Regards,Koen De Groote


On Wed, Nov 20, 2024 at 12:38 AM Thomas Munro <[email protected]> wrote:
On Wed, Nov 20, 2024 at 11:22 AM Koen De Groote <[email protected]> wrote:

> Why would that be? It's the exact same data. The install is about 50GB in size. Is there something wrong with postgres 16, or did some settings significantly change, that I need to know about? I went over all the changelogs, nothing stood out as relevant to this, but that might be a lack of experience on my end.



Parallel vacuum arrived in PostgreSQL 13, and that uses "dynamic

shared memory" to share state between workers, and assuming

dynamic_shared_memory_type=posix, that means shm_open(), which opens

files under /dev/shm on Linux.

view thread (4+ messages)

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]
  Subject: Re: Running docker in postgres, SHM size of the docker container in postgres 16
  In-Reply-To: <[email protected]>

* 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