Re: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs)

От

Julien Rouhaud

Тема

Дата

17 февраля 2022 г. в 11:05:15

Msg-id

20220217110515.zssjnez4lq2lmrdq@jrouhaud

обсуждение

Ответ на

Re: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs) (Nitin Jadhav)

Список

pgsql-hackers

Дерево обсуждения

Report checkpoint progress in server logs Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com> 29 декабря 2021 г. в 14:30:54

Re: Report checkpoint progress in server logs Magnus Hagander <magnus@hagander.net> 29 декабря 2021 г. в 14:35:40

Re: Report checkpoint progress in server logs Tom Lane <tgl@sss.pgh.pa.us> 29 декабря 2021 г. в 15:40:59

Re: Report checkpoint progress in server logs SATYANARAYANA NARLAPURAM <satyanarlapuram@gmail.com> 29 декабря 2021 г. в 18:54:06

Re: Report checkpoint progress in server logs Michael Paquier <michael@paquier.xyz> 4 января 2022 г. в 12:11:29

Re: Report checkpoint progress in server logs Bruce Momjian <bruce@momjian.us> 5 января 2022 г. в 23:42:24

Re: Report checkpoint progress in server logs Nitin Jadhav <nitinjadhavpostgres@gmail.com> 21 января 2022 г. в 05:37:18

Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs) Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com> 28 января 2022 г. в 06:54:48

Re: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs) Nitin Jadhav <nitinjadhavpostgres@gmail.com> 10 февраля 2022 г. в 06:52:48

Re: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs) Ashutosh Sharma <ashu.coek88@gmail.com> 22 февраля 2022 г. в 14:40:02

Re: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs) Nitin Jadhav <nitinjadhavpostgres@gmail.com> 23 февраля 2022 г. в 13:37:01

Re: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs) Matthias van de Meent <boekewurm+postgres@gmail.com> 16 февраля 2022 г. в 20:02:45

Re: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs) Nitin Jadhav <nitinjadhavpostgres@gmail.com> 18 февраля 2022 г. в 06:32:49

Re: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs) Nitin Jadhav <nitinjadhavpostgres@gmail.com> 17 февраля 2022 г. в 06:56:07

Re: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs) Julien Rouhaud <rjuju123@gmail.com> 17 февраля 2022 г. в 11:05:15

Re: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs) Nitin Jadhav <nitinjadhavpostgres@gmail.com> 17 февраля 2022 г. в 17:09:02

Re: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs) Julien Rouhaud <rjuju123@gmail.com> 17 февраля 2022 г. в 17:27:24

Re: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs) Nitin Jadhav <nitinjadhavpostgres@gmail.com> 18 февраля 2022 г. в 06:50:26

Re: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs) Julien Rouhaud <rjuju123@gmail.com> 18 февраля 2022 г. в 07:43:51

Re: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs) Nitin Jadhav <nitinjadhavpostgres@gmail.com> 18 февраля 2022 г. в 14:37:05

Re: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs) Julien Rouhaud <rjuju123@gmail.com> 19 февраля 2022 г. в 05:32:15

Re: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs) Nitin Jadhav <nitinjadhavpostgres@gmail.com> 22 февраля 2022 г. в 06:38:33

Re: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs) Matthias van de Meent <boekewurm+postgres@gmail.com> 22 февраля 2022 г. в 18:42:54

Re: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs) Nitin Jadhav <nitinjadhavpostgres@gmail.com> 23 февраля 2022 г. в 14:23:28

Re: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs) Matthias van de Meent <boekewurm+postgres@gmail.com> 23 февраля 2022 г. в 19:50:59

Re: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs) Nitin Jadhav <nitinjadhavpostgres@gmail.com> 23 февраля 2022 г. в 13:28:14

Re: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs) Alvaro Herrera <alvherre@alvh.no-ip.org> 23 февраля 2022 г. в 18:39:04

Re: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs) Justin Pryzby <pryzby@telsasoft.com> 23 февраля 2022 г. в 19:22:10

Re: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs) Ashutosh Sharma <ashu.coek88@gmail.com> 23 февраля 2022 г. в 16:16:28

Re: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs) Nitin Jadhav <nitinjadhavpostgres@gmail.com> 25 февраля 2022 г. в 15:07:28

Re: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs) Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com> 27 февраля 2022 г. в 15:14:39

Re: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs) Matthias van de Meent <boekewurm+postgres@gmail.com> 28 февраля 2022 г. в 13:10:25

Re: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs) Nitin Jadhav <nitinjadhavpostgres@gmail.com> 1 марта 2022 г. в 08:57:04

Re: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs) Nitin Jadhav <nitinjadhavpostgres@gmail.com> 2 марта 2022 г. в 11:15:20

Re: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs) Ashutosh Sharma <ashu.coek88@gmail.com> 3 марта 2022 г. в 15:00:10

Re: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs) Nitin Jadhav <nitinjadhavpostgres@gmail.com> 7 марта 2022 г. в 14:45:28

Re: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs) Nitin Jadhav <nitinjadhavpostgres@gmail.com> 8 марта 2022 г. в 15:00:49

Re: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs) Ashutosh Sharma <ashu.coek88@gmail.com> 9 марта 2022 г. в 13:37:32

Re: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs) Nitin Jadhav <nitinjadhavpostgres@gmail.com> 11 марта 2022 г. в 08:47:59

Re: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs) Nitin Jadhav <nitinjadhavpostgres@gmail.com> 7 марта 2022 г. в 14:15:50

Re: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs) Nitin Jadhav <nitinjadhavpostgres@gmail.com> 8 марта 2022 г. в 14:55:28

Re: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs) Andres Freund <andres@anarazel.de> 19 марта 2022 г. в 00:15:56

Size of pg_rewrite (Was: Report checkpoint progress with pg_stat_progress_checkpoint) Matthias van de Meent <boekewurm+postgres@gmail.com> 8 апреля 2022 г. в 14:52:07

Re: Size of pg_rewrite (Was: Report checkpoint progress with pg_stat_progress_checkpoint) Andres Freund <andres@anarazel.de> 8 апреля 2022 г. в 16:09:34

Re: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs) Nitin Jadhav <nitinjadhavpostgres@gmail.com> 13 июня 2022 г. в 13:38:35

Re: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs) Andres Freund <andres@anarazel.de> 7 июля 2022 г. в 00:04:46

Re: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs) Nitin Jadhav <nitinjadhavpostgres@gmail.com> 28 июля 2022 г. в 09:38:38

Re: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs) "Drouvot, Bertrand" <bertranddrouvot.pg@gmail.com> 4 ноября 2022 г. в 08:25:52

Re: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs) Andres Freund <andres@anarazel.de> 15 ноября 2022 г. в 20:18:11

Re: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs) Andres Freund <andres@anarazel.de> 7 декабря 2022 г. в 19:03:49

Re: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs) vignesh C <vignesh21@gmail.com> 31 января 2023 г. в 17:46:27

Re: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs) Nitin Jadhav <nitinjadhavpostgres@gmail.com> 7 октября 2024 г. в 11:36:54

Re: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs) Robert Haas <robertmhaas@gmail.com> 15 ноября 2022 г. в 20:04:59

Re: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs) Andres Freund <andres@anarazel.de> 16 ноября 2022 г. в 18:14:33

Re: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs) Robert Haas <robertmhaas@gmail.com> 16 ноября 2022 г. в 19:19:32

Re: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs) Andres Freund <andres@anarazel.de> 16 ноября 2022 г. в 19:52:32

Re: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs) Robert Haas <robertmhaas@gmail.com> 17 ноября 2022 г. в 14:03:32

Re: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs) Andres Freund <andres@anarazel.de> 17 ноября 2022 г. в 16:24:31

Re: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs) Tom Lane <tgl@sss.pgh.pa.us> 17 ноября 2022 г. в 17:18:00

Re: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs) Robert Haas <robertmhaas@gmail.com> 17 ноября 2022 г. в 17:21:03

Re: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs) Nitin Jadhav <nitinjadhavpostgres@gmail.com> 15 ноября 2022 г. в 11:41:52

Re: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs) Michael Paquier <michael@paquier.xyz> 5 апреля 2022 г. в 09:45:44

Re: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs) Nitin Jadhav <nitinjadhavpostgres@gmail.com> 13 июня 2022 г. в 13:56:39

Re: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs) Julien Rouhaud <rjuju123@gmail.com> 3 марта 2022 г. в 18:28:02

Re: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs) Nitin Jadhav <nitinjadhavpostgres@gmail.com> 8 марта 2022 г. в 15:27:23

Re: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs) Julien Rouhaud <rjuju123@gmail.com> 9 марта 2022 г. в 14:17:50

Re: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs) Nitin Jadhav <nitinjadhavpostgres@gmail.com> 11 марта 2022 г. в 09:11:23

Re: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs) Julien Rouhaud <rjuju123@gmail.com> 11 марта 2022 г. в 10:04:28

Re: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs) Nitin Jadhav <nitinjadhavpostgres@gmail.com> 11 марта 2022 г. в 11:29:11

Re: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs) Julien Rouhaud <rjuju123@gmail.com> 11 марта 2022 г. в 12:13:00

Re: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs) Nitin Jadhav <nitinjadhavpostgres@gmail.com> 14 марта 2022 г. в 09:46:50

Re: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs) Julien Rouhaud <rjuju123@gmail.com> 14 марта 2022 г. в 11:45:55

Re: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs) Nitin Jadhav <nitinjadhavpostgres@gmail.com> 18 марта 2022 г. в 11:22:52

Re: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs) Nitin Jadhav <nitinjadhavpostgres@gmail.com> 6 июня 2022 г. в 06:03:50

Re: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs) Nitin Jadhav <nitinjadhavpostgres@gmail.com> 4 марта 2022 г. в 11:29:04

Re: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs) Ashutosh Sharma <ashu.coek88@gmail.com> 4 марта 2022 г. в 12:20:47

Re: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs) Julien Rouhaud <rjuju123@gmail.com> 28 февраля 2022 г. в 06:32:22

Re: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs) Julien Rouhaud <rjuju123@gmail.com> 28 февраля 2022 г. в 12:58:58

Re: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs) Matthias van de Meent <boekewurm+postgres@gmail.com> 24 февраля 2022 г. в 17:14:53

Re: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs) Nitin Jadhav <nitinjadhavpostgres@gmail.com> 24 февраля 2022 г. в 18:53:27

Re: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs) Julien Rouhaud <rjuju123@gmail.com> 25 февраля 2022 г. в 07:03:52

Re: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs) Nitin Jadhav <nitinjadhavpostgres@gmail.com> 25 февраля 2022 г. в 15:23:50

Re: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs) Julien Rouhaud <rjuju123@gmail.com> 25 февраля 2022 г. в 16:35:45

Re: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs) Matthias van de Meent <boekewurm+postgres@gmail.com> 25 февраля 2022 г. в 17:49:42

Re: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs) Julien Rouhaud <rjuju123@gmail.com> 25 февраля 2022 г. в 18:30:36

Re: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs) Julien Rouhaud <rjuju123@gmail.com> 25 февраля 2022 г. в 18:37:30

Re: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs) Nitin Jadhav <nitinjadhavpostgres@gmail.com> 25 февраля 2022 г. в 14:56:27

Re: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs) Matthias van de Meent <boekewurm+postgres@gmail.com> 17 февраля 2022 г. в 11:11:09

Re: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs) Nitin Jadhav <nitinjadhavpostgres@gmail.com> 15 февраля 2022 г. в 12:15:26

Hi,

On Thu, Feb 17, 2022 at 12:26:07PM +0530, Nitin Jadhav wrote:
> 
> Thank you for sharing the information.  'triggering backend PID' (int)
> - can be stored without any problem.

There can be multiple processes triggering a checkpoint, or at least wanting it
to happen or happen faster.

> 'checkpoint or restartpoint?'

Do you actually need to store that?  Can't it be inferred from
pg_is_in_recovery()?

В списке pgsql-hackers по дате отправления

Предыдущее

От: Amit Kapila

Дата: 17 февраля 2022 г. в 10:42:24

Сообщение: Re: logical replication empty transactions

Следующее

От: Matthias van de Meent

Дата: 17 февраля 2022 г. в 11:11:09

Сообщение: Re: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs)