| 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 |
| Thread: | |
| 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: https://aws.amazon.com
| Attachment | Content-Type | Size |
|---|---|---|
| v3-0001-Silence-extra-logging-with-postgres-C.patch | text/x-diff | 3.2 KB |
| 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 |
| 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 |