Re: when the startup process doesn't (logging startup delays)

Поиск
Список
Период
Сортировка
Искать
От
Tom Lane
Тема
Re: when the startup process doesn't (logging startup delays)
Дата
Msg-id
2992585.1632938816@sss.pgh.pa.us
Ответ на
Список
Дерево обсуждения
when the startup process doesn't Robert Haas <robertmhaas@gmail.com>
Re: when the startup process doesn't Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: when the startup process doesn't Bruce Momjian <bruce@momjian.us>
Re: when the startup process doesn't Andres Freund <andres@anarazel.de>
Re: when the startup process doesn't Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: when the startup process doesn't Thomas Munro <thomas.munro@gmail.com>
Re: when the startup process doesn't Tom Lane <tgl@sss.pgh.pa.us>
Re: when the startup process doesn't Robert Haas <robertmhaas@gmail.com>
Re: when the startup process doesn't Magnus Hagander <magnus@hagander.net>
Re: when the startup process doesn't Jehan-Guillaume de Rorthais <jgdr@dalibo.com>
Re: when the startup process doesn't Magnus Hagander <magnus@hagander.net>
Re: when the startup process doesn't Tom Lane <tgl@sss.pgh.pa.us>
Re: when the startup process doesn't Stephen Frost <sfrost@snowman.net>
Re: when the startup process doesn't Tom Lane <tgl@sss.pgh.pa.us>
Re: when the startup process doesn't Stephen Frost <sfrost@snowman.net>
Re: when the startup process doesn't Andres Freund <andres@anarazel.de>
Re: when the startup process doesn't Stephen Frost <sfrost@snowman.net>
Re: when the startup process doesn't Andres Freund <andres@anarazel.de>
Re: when the startup process doesn't Stephen Frost <sfrost@snowman.net>
Re: when the startup process doesn't Andres Freund <andres@anarazel.de>
Re: when the startup process doesn't Stephen Frost <sfrost@snowman.net>
Re: when the startup process doesn't Andres Freund <andres@anarazel.de>
Re: when the startup process doesn't Tom Lane <tgl@sss.pgh.pa.us>
Re: when the startup process doesn't Andres Freund <andres@anarazel.de>
Re: when the startup process doesn't Stephen Frost <sfrost@snowman.net>
Re: when the startup process doesn't Jehan-Guillaume de Rorthais <jgdr@dalibo.com>
Re: when the startup process doesn't Nitin Jadhav <nitinjadhavpostgres@gmail.com>
Re: when the startup process doesn't Justin Pryzby <pryzby@telsasoft.com>
Re: when the startup process doesn't Robert Haas <robertmhaas@gmail.com>
Re: when the startup process doesn't Tom Lane <tgl@sss.pgh.pa.us>
Re: when the startup process doesn't Nitin Jadhav <nitinjadhavpostgres@gmail.com>
Re: when the startup process doesn't Justin Pryzby <pryzby@telsasoft.com>
Re: when the startup process doesn't Nitin Jadhav <nitinjadhavpostgres@gmail.com>
Re: when the startup process doesn't Justin Pryzby <pryzby@telsasoft.com>
Re: when the startup process doesn't Nitin Jadhav <nitinjadhavpostgres@gmail.com>
Re: when the startup process doesn't (logging startup delays) Justin Pryzby <pryzby@telsasoft.com>
Re: when the startup process doesn't (logging startup delays) Nitin Jadhav <nitinjadhavpostgres@gmail.com>
Re: when the startup process doesn't (logging startup delays) Amul Sul <sulamul@gmail.com>
Re: when the startup process doesn't (logging startup delays) Robert Haas <robertmhaas@gmail.com>
Re: when the startup process doesn't (logging startup delays) Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: when the startup process doesn't (logging startup delays) Nitin Jadhav <nitinjadhavpostgres@gmail.com>
Re: when the startup process doesn't (logging startup delays) Justin Pryzby <pryzby@telsasoft.com>
Re: when the startup process doesn't (logging startup delays) Nitin Jadhav <nitinjadhavpostgres@gmail.com>
Re: when the startup process doesn't (logging startup delays) Justin Pryzby <pryzby@telsasoft.com>
Re: when the startup process doesn't (logging startup delays) Robert Haas <robertmhaas@gmail.com>
Re: when the startup process doesn't (logging startup delays) Justin Pryzby <pryzby@telsasoft.com>
Re: when the startup process doesn't (logging startup delays) Justin Pryzby <pryzby@telsasoft.com>
Re: when the startup process doesn't (logging startup delays) Robert Haas <robertmhaas@gmail.com>
Re: when the startup process doesn't (logging startup delays) Nitin Jadhav <nitinjadhavpostgres@gmail.com>
Re: when the startup process doesn't (logging startup delays) Nitin Jadhav <nitinjadhavpostgres@gmail.com>
Re: when the startup process doesn't (logging startup delays) Justin Pryzby <pryzby@telsasoft.com>
Re: when the startup process doesn't (logging startup delays) Michael Paquier <michael@paquier.xyz>
Re: when the startup process doesn't (logging startup delays) Nitin Jadhav <nitinjadhavpostgres@gmail.com>
Re: when the startup process doesn't (logging startup delays) Justin Pryzby <pryzby@telsasoft.com>
Re: when the startup process doesn't (logging startup delays) Nitin Jadhav <nitinjadhavpostgres@gmail.com>
Re: when the startup process doesn't (logging startup delays) Nitin Jadhav <nitinjadhavpostgres@gmail.com>
Re: when the startup process doesn't (logging startup delays) Robert Haas <robertmhaas@gmail.com>
Re: when the startup process doesn't (logging startup delays) Nitin Jadhav <nitinjadhavpostgres@gmail.com>
Re: when the startup process doesn't (logging startup delays) Justin Pryzby <pryzby@telsasoft.com>
Re: when the startup process doesn't (logging startup delays) Robert Haas <robertmhaas@gmail.com>
Re: when the startup process doesn't (logging startup delays) Nitin Jadhav <nitinjadhavpostgres@gmail.com>
Re: when the startup process doesn't (logging startup delays) Robert Haas <robertmhaas@gmail.com>
Re: when the startup process doesn't (logging startup delays) Nitin Jadhav <nitinjadhavpostgres@gmail.com>
Re: when the startup process doesn't (logging startup delays) Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: when the startup process doesn't (logging startup delays) Justin Pryzby <pryzby@telsasoft.com>
Re: when the startup process doesn't (logging startup delays) Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: when the startup process doesn't (logging startup delays) Robert Haas <robertmhaas@gmail.com>
Re: when the startup process doesn't (logging startup delays) Robert Haas <robertmhaas@gmail.com>
Re: when the startup process doesn't (logging startup delays) Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: when the startup process doesn't (logging startup delays) Tom Lane <tgl@sss.pgh.pa.us>
Re: when the startup process doesn't (logging startup delays) Robert Haas <robertmhaas@gmail.com>
Re: when the startup process doesn't (logging startup delays) Tom Lane <tgl@sss.pgh.pa.us>
Re: when the startup process doesn't (logging startup delays) Robert Haas <robertmhaas@gmail.com>
Re: when the startup process doesn't (logging startup delays) Tom Lane <tgl@sss.pgh.pa.us>
Re: when the startup process doesn't (logging startup delays) Robert Haas <robertmhaas@gmail.com>
Re: when the startup process doesn't (logging startup delays) Robert Haas <robertmhaas@gmail.com>
Re: when the startup process doesn't (logging startup delays) Nitin Jadhav <nitinjadhavpostgres@gmail.com>
Re: when the startup process doesn't (logging startup delays) Robert Haas <robertmhaas@gmail.com>
Re: when the startup process doesn't (logging startup delays) Robert Haas <robertmhaas@gmail.com>
Re: when the startup process doesn't (logging startup delays) Nitin Jadhav <nitinjadhavpostgres@gmail.com>
Re: when the startup process doesn't (logging startup delays) Robert Haas <robertmhaas@gmail.com>
Re: when the startup process doesn't (logging startup delays) Nitin Jadhav <nitinjadhavpostgres@gmail.com>
Re: when the startup process doesn't (logging startup delays) Robert Haas <robertmhaas@gmail.com>
Re: when the startup process doesn't (logging startup delays) Thomas Munro <thomas.munro@gmail.com>
Re: when the startup process doesn't (logging startup delays) Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: when the startup process doesn't (logging startup delays) Simon Riggs <simon.riggs@enterprisedb.com>
Re: when the startup process doesn't (logging startup delays) Robert Haas <robertmhaas@gmail.com>
Re: when the startup process doesn't (logging startup delays) Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: when the startup process doesn't (logging startup delays) Robert Haas <robertmhaas@gmail.com>
Re: when the startup process doesn't (logging startup delays) Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: when the startup process doesn't (logging startup delays) Robert Haas <robertmhaas@gmail.com>
Re: when the startup process doesn't (logging startup delays) Thomas Munro <thomas.munro@gmail.com>
Re: when the startup process doesn't (logging startup delays) Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: when the startup process doesn't (logging startup delays) Robert Haas <robertmhaas@gmail.com>
Re: when the startup process doesn't (logging startup delays) Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: when the startup process doesn't (logging startup delays) Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: when the startup process doesn't (logging startup delays) Robert Haas <robertmhaas@gmail.com>
Re: when the startup process doesn't (logging startup delays) Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: when the startup process doesn't (logging startup delays) Robert Haas <robertmhaas@gmail.com>
Re: when the startup process doesn't (logging startup delays) Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: when the startup process doesn't (logging startup delays) Robert Haas <robertmhaas@gmail.com>
Re: when the startup process doesn't (logging startup delays) Tom Lane <tgl@sss.pgh.pa.us>
Re: when the startup process doesn't (logging startup delays) Robert Haas <robertmhaas@gmail.com>
Re: when the startup process doesn't (logging startup delays) Tom Lane <tgl@sss.pgh.pa.us>
Re: when the startup process doesn't (logging startup delays) Robert Haas <robertmhaas@gmail.com>
Re: when the startup process doesn't (logging startup delays) Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: when the startup process doesn't (logging startup delays) Tom Lane <tgl@sss.pgh.pa.us>
Re: when the startup process doesn't (logging startup delays) Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: when the startup process doesn't (logging startup delays) Simon Riggs <simon.riggs@enterprisedb.com>
Re: when the startup process doesn't (logging startup delays) Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: when the startup process doesn't (logging startup delays) Simon Riggs <simon.riggs@enterprisedb.com>
Re: when the startup process doesn't (logging startup delays) Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: when the startup process doesn't (logging startup delays) Robert Haas <robertmhaas@gmail.com>
Re: when the startup process doesn't (logging startup delays) Michael Paquier <michael@paquier.xyz>
Re: when the startup process doesn't (logging startup delays) Robert Haas <robertmhaas@gmail.com>
Re: when the startup process doesn't (logging startup delays) Amul Sul <sulamul@gmail.com>
Re: when the startup process doesn't (logging startup delays) Robert Haas <robertmhaas@gmail.com>
Re: when the startup process doesn't (logging startup delays) Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: when the startup process doesn't (logging startup delays) Robert Haas <robertmhaas@gmail.com>
Re: when the startup process doesn't (logging startup delays) Nitin Jadhav <nitinjadhavpostgres@gmail.com>
Re: when the startup process doesn't (logging startup delays) Robert Haas <robertmhaas@gmail.com>
Re: when the startup process doesn't (logging startup delays) Nitin Jadhav <nitinjadhavpostgres@gmail.com>
Re: when the startup process doesn't (logging startup delays) Robert Haas <robertmhaas@gmail.com>
Re: when the startup process doesn't (logging startup delays) Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: when the startup process doesn't (logging startup delays) Robert Haas <robertmhaas@gmail.com>
Re: when the startup process doesn't (logging startup delays) Nitin Jadhav <nitinjadhavpostgres@gmail.com>
Re: when the startup process doesn't (logging startup delays) Robert Haas <robertmhaas@gmail.com>
Re: when the startup process doesn't (logging startup delays) Nitin Jadhav <nitinjadhavpostgres@gmail.com>
Re: when the startup process doesn't (logging startup delays) Nitin Jadhav <nitinjadhavpostgres@gmail.com>
Re: when the startup process doesn't (logging startup delays) Justin Pryzby <pryzby@telsasoft.com>
Re: when the startup process doesn't (logging startup delays) Robert Haas <robertmhaas@gmail.com>
Re: when the startup process doesn't (logging startup delays) Nitin Jadhav <nitinjadhavpostgres@gmail.com>
Re: when the startup process doesn't (logging startup delays) Robert Haas <robertmhaas@gmail.com>
Re: when the startup process doesn't (logging startup delays) Nitin Jadhav <nitinjadhavpostgres@gmail.com>
Re: when the startup process doesn't (logging startup delays) Robert Haas <robertmhaas@gmail.com>
Re: when the startup process doesn't (logging startup delays) Nitin Jadhav <nitinjadhavpostgres@gmail.com>
Re: when the startup process doesn't (logging startup delays) Robert Haas <robertmhaas@gmail.com>
Re: when the startup process doesn't (logging startup delays) Nitin Jadhav <nitinjadhavpostgres@gmail.com>
Re: when the startup process doesn't (logging startup delays) Robert Haas <robertmhaas@gmail.com>
Re: when the startup process doesn't (logging startup delays) Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: when the startup process doesn't Tom Lane <tgl@sss.pgh.pa.us>
Re: when the startup process doesn't Magnus Hagander <magnus@hagander.net>
Re: when the startup process doesn't SATYANARAYANA NARLAPURAM <satyanarlapuram@gmail.com>
Alvaro Herrera  writes:
> On 2021-Sep-29, Robert Haas wrote:
>> Well, this was my suggestion, because if you don't do this, you get
>> drift, which I think looks weird. Like the timestamps will be:
>> 
>> 13:41:05.012456
>> 13:41:15.072484
>> 13:41:25.149632
>> 
>> ...and it gets further and further off as it goes on.'

> Right ... I actually *expect* this drift to occur.  Maybe people
> generally don't like this, it just seems natural to me.  Are there other
> opinions on this aspect?

FWIW, I agree with Robert that it's nicer if the timeout doesn't drift.
There's a limit to how much complexity I'm willing to tolerate for that,
but it doesn't seem like this exceeds it.

The real comment I'd have here, though, is that writing one-off
code for this purpose is bad.  If we have a need for a repetitive
timeout, it'd be better to add the feature to timeout.c explicitly.
That would probably also remove the need for extra copies of the
timeout time.

			regards, tom lane


В списке pgsql-hackers по дате отправления
От: Tom Lane
Дата:
От: Ranier Vilela
Дата:
FAQ