public inbox for [email protected]
help / color / mirror / Atom feedFrom: [email protected]
To: Roberto Mello <[email protected]>
To: Cary Huang <[email protected]>
Cc: [email protected]
Subject: Re: [DOC] Add detail regarding resource consumption wrt max_connections
Date: Mon, 22 Jan 2024 08:58:23 -0500
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <CAKz==bJBCWrvN77fmuZ2XqD3jazWEb=E80AA4Yv9C9tQ61YDdQ@mail.gmail.com>
<170509767861.1131.15083983626399995184.pgcf@coridan.postgresql.org>
<CAKz==bLJAwDGMMRqJSwA0Y+h10OYff73cd1pNCyzGnwYLq74BA@mail.gmail.com>
<[email protected]>
On Fri, 2024-01-19 at 17:37 -0500, [email protected] wrote:
> On Sat, 2024-01-13 at 10:31 -0700, Roberto Mello wrote:
> >
> > I can add a suggestion for the user to consider increasing
> > shared_buffers in accordance with higher max_connections, but it
> > would be better if there was a "rule of thumb" guideline to go
> > along. I'm open to suggestions.
> >
> > I can revise with a similar warning in max_prepared_xacts as well.
> >
> > Sincerely,
> >
> > Roberto
>
> Can a "close enough" rule of thumb be calculated from:
> postgresql.conf -> log_min_messages = debug3
>
> start postgresql with varying max_connections to get
> CreateSharedMemoryAndSemaphores() sizes to generate a rough equation
>
or maybe it would be sufficient to advise to set log_min_messages =
debug3 on a test DB and start/stop it with varying values of
max_connections and look at the differing values in
DEBUG: invoking IpcMemoryCreate(size=...) log messages for themselves.
view thread (5+ 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], [email protected], [email protected]
Subject: Re: [DOC] Add detail regarding resource consumption wrt max_connections
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