From: Stephen Frost <sfrost@snowman.net>
To: Andres Freund <andres@anarazel.de>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Magnus Hagander <magnus@hagander.net>
Cc: Jehan-Guillaume de Rorthais <jgdr@dalibo.com>
Cc: Robert Haas <robertmhaas@gmail.com>
Cc: Thomas Munro <thomas.munro@gmail.com>
Cc: pgsql-hackers@postgresql.org <pgsql-hackers@postgresql.org>
Subject: Re: when the startup process doesn't
Date: Wed, 21 Apr 2021 16:28:26 -0400
Message-ID: <20210421202826.GS20766@tamriel.snowman.net> (raw)
In-Reply-To: <20210421200032.ojzbrbdhrqw7nroa@alap3.anarazel.de>
References: <20210420171720.56599607@firost>
<CABUevEyTBiiDvjdKo5h=gj6W1uL6i4jOOV4nur0YZsuKvKRVXw@mail.gmail.com>
<631849.1618942988@sss.pgh.pa.us>
<20210420185150.GL20766@tamriel.snowman.net>
<633337.1618945018@sss.pgh.pa.us>
<20210420203642.nvxvolm37f2k6prj@alap3.anarazel.de>
<20210421183624.GP20766@tamriel.snowman.net>
<20210421193605.cubavrq7q5bqkf4i@alap3.anarazel.de>
<20210421195138.GQ20766@tamriel.snowman.net>
<20210421200032.ojzbrbdhrqw7nroa@alap3.anarazel.de>
Greetings,
* Andres Freund (andres@anarazel.de) wrote:
> On 2021-04-21 15:51:38 -0400, Stephen Frost wrote:
> > It does seem like we have some trade-offs here to weigh, but
> > pg_control is indeed quite small..
>
> What do you mean by that? That the overhead of writing it out more
> frequently wouldn't be too bad? Or that we shouldn't "unnecessarily" add
> more fields to it?
Mostly just that the added overhead in writing it out more frequently
wouldn't be too bad. Adding fields runs the risk of crossing the
threshold where we feel that we can safely assume all of it will make it
to disk in one shot and therefore there's more reason to not add extra
fields to it, if possible.
Seems the missing bit here is "how often, and how do we make that
happen?" and then we can discuss if there's reason to be concerned that
it would be 'too frequent' or cause too much additional overhead in
terms of IO/fsyncs.
Thanks,
Stephen
Attachments:
signature.asc (application/pgp-signature, 818B) download
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: pgsql-hackers@postgresql.org
Cc: sfrost@snowman.net, andres@anarazel.de, tgl@sss.pgh.pa.us, magnus@hagander.net, jgdr@dalibo.com, robertmhaas@gmail.com, thomas.munro@gmail.com
Subject: Re: when the startup process doesn't
In-Reply-To: <20210421202826.GS20766@tamriel.snowman.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox