Re: when the startup process doesn't - Mailing list pgsql-hackers

From Tom Lane
Subject Re: when the startup process doesn't
Date
Msg-id 465221.1618879471@sss.pgh.pa.us
Whole thread Raw
In response to Re: when the startup process doesn't  (Thomas Munro <thomas.munro@gmail.com>)
Responses Re: when the startup process doesn't  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Thomas Munro <thomas.munro@gmail.com> writes:
> On Tue, Apr 20, 2021 at 5:55 AM Robert Haas <robertmhaas@gmail.com> wrote:
>> If I had to pick one of these two ideas, I'd pick the one the
>> log-based solution, since it seems easier to access and simplifies
>> retrospective analysis, but I suspect SQL access would be quite useful
>> for some users too, especially in cloud environments where "just log
>> into the machine and have a look" is not an option.

> +1 for both ideas.  I've heard multiple requests for something like
> that.  A couple of users with update_process_title=off told me they
> regretted that choice when they found themselves running a long crash
> recovery with the only indicator of progress disabled.

Hmm ... +1 for progress messages in the log, but I'm suspicious about
the complexity-and-fragility-versus-value tradeoff for the other thing.

            regards, tom lane



pgsql-hackers by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: partial heap only tuples
Next
From: Yugo NAGATA
Date:
Subject: Re: Implementing Incremental View Maintenance