Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps
 (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1lqFWY-0008K2-7Y
	for pgsql-hackers@arkaria.postgresql.org; Mon, 07 Jun 2021 13:42:38 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1lqFWW-000473-Ai
	for pgsql-hackers@arkaria.postgresql.org; Mon, 07 Jun 2021 13:42:36 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <tgl@sss.pgh.pa.us>)
	id 1lqFWW-00046u-34
	for pgsql-hackers@lists.postgresql.org; Mon, 07 Jun 2021 13:42:36 +0000
Received: from sss.pgh.pa.us ([66.207.139.130])
	by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <tgl@sss.pgh.pa.us>)
	id 1lqFWU-0006Rq-2f
	for pgsql-hackers@postgresql.org; Mon, 07 Jun 2021 13:42:35 +0000
Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1])
	by sss.pgh.pa.us (8.15.2/8.15.2) with ESMTP id 157DgTfF867287;
	Mon, 7 Jun 2021 09:42:29 -0400
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Robert Haas <robertmhaas@gmail.com>
cc: Justin Pryzby <pryzby@telsasoft.com>,
        Nitin Jadhav <nitinjadhavpostgres@gmail.com>,
        Andres Freund <andres@anarazel.de>,
 Stephen Frost <sfrost@snowman.net>,
        Magnus Hagander <magnus@hagander.net>,
        Thomas Munro <thomas.munro@gmail.com>,
        "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>
Subject: Re: when the startup process doesn't
In-reply-to: 
 <CA+TgmoaG+FzfoWi3dkvZM48256vmE0CZnppgGjq6EiPw=f4OpQ@mail.gmail.com>
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>
 <20210422010919.4b655015@firost>
 <CAMm1aWYAjwui2OrY6TSvVF8N9YLdRdnO5BUS-t5GDR60X1FanQ@mail.gmail.com>
 <20210606222305.GZ14099@telsasoft.com>
 <CA+TgmoaG+FzfoWi3dkvZM48256vmE0CZnppgGjq6EiPw=f4OpQ@mail.gmail.com>
Comments: In-reply-to Robert Haas <robertmhaas@gmail.com>
	message dated "Mon, 07 Jun 2021 09:21:05 -0400"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <867285.1623073349.1@sss.pgh.pa.us>
Date: Mon, 07 Jun 2021 09:42:29 -0400
Message-ID: <867286.1623073349@sss.pgh.pa.us>
List-Id: <pgsql-hackers.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-hackers@lists.postgresql.org>
List-Owner: <mailto:pgsql-hackers-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-hackers>
Archived-At: 
 <https://www.postgresql.org/message-id/867286.1623073349%40sss.pgh.pa.us>
Precedence: bulk

Robert Haas <robertmhaas@gmail.com> writes:
> ... I doubt that we can get away
> with a GetCurrentTimestamp() after applying every WAL record ... that
> seems like it will be slow.

Yeah, that's going to be pretty awful even on machines with fast
gettimeofday, never mind ones where it isn't.

It should be possible to use utils/misc/timeout.c to manage the
interrupt, I'd think.

			regards, tom lane