Re: Estimating HugePages Requirements?

From: Nathan Bossart <nathandbossart(at)gmail(dot)com>
To: Magnus Hagander <magnus(at)hagander(dot)net>
Cc: Michael Paquier <michael(at)paquier(dot)xyz>, "Bossart, Nathan" <bossartn(at)amazon(dot)com>, Fujii Masao <masao(dot)fujii(at)oss(dot)nttdata(dot)com>, Justin Pryzby <pryzby(at)telsasoft(dot)com>, Andres Freund <andres(at)anarazel(dot)de>, Mark Dilger <mark(dot)dilger(at)enterprisedb(dot)com>, Don Seiler <don(at)seiler(dot)us>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Estimating HugePages Requirements?
Date: 2022-03-28 17:35:03
Message-ID: 20220328173503.GA137769@nathanxps13
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-admin pgsql-hackers

On Thu, Mar 24, 2022 at 01:31:08PM -0700, Nathan Bossart wrote:
> A couple of other options to consider:
> 1) Always set log_min_messages to WARNING/ERROR/FATAL for 'postgres -C'.
> We might need some special logic for handling the case where the user is
> inspecting the log_min_messages parameter. With this approach, you'd
> probably never get extra output unless something was wrong (e.g., database
> already running when inspecting a runtime-computed GUC). Also, this would
> silence any extra output that you might see today with non-runtime-computed
> GUCs.
> 2) Add some way to skip just the shutdown message (e.g., a variable set
> when output_config_variable is true). With this approach, you wouldn't get
> extra output by default, but you still might if log_min_messages is set to
> something like DEBUG3. This wouldn't impact any extra output that you see
> today with non-runtime-computed GUCs.

I've attached a first attempt at option 1.

Nathan Bossart
Amazon Web Services:

Attachment Content-Type Size
v3-0001-Silence-extra-logging-with-postgres-C.patch text/x-diff 3.2 KB

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message 荒井元成 2022-03-29 03:26:35 About Unicode IVS
Previous Message Loles 2022-03-27 05:23:44 Re: Avoid Wraparound Failures

Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2022-03-28 18:00:45 Re: Extensible Rmgr for Table AMs
Previous Message Robert Haas 2022-03-28 17:32:34 Re: multithreaded zstd backup compression for client and server