Re: error context for vacuum to include block number

From:	Justin Pryzby <pryzby(at)telsasoft(dot)com>
To:	Michael Paquier <michael(at)paquier(dot)xyz>
Cc:	Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Andres Freund <andres(at)anarazel(dot)de>, pgsql-hackers(at)postgresql(dot)org
Subject:	Re: error context for vacuum to include block number
Date:	2020-01-20 05:41:59
Message-ID:	20200120054159.GT26045@telsasoft.com
Views:	Raw Message | Whole Thread | Download mbox | Resend email
Thread:	2019-11-20 21:06:00 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 📎  2019-12-06 16:23:25 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 📎   2019-12-11 12:15:07 from Michael Paquier <michael(at)paquier(dot)xyz>    2019-12-11 14:36:48 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 📎     2019-12-11 15:33:53 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>     2019-12-11 16:54:25 from Andres Freund <andres(at)anarazel(dot)de>      2019-12-13 03:08:31 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 📎       2019-12-13 13:28:50 from Michael Paquier <michael(at)paquier(dot)xyz>        2019-12-13 22:47:35 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 📎         2019-12-15 13:07:08 from Michael Paquier <michael(at)paquier(dot)xyz>          2019-12-15 16:27:12 from Justin Pryzby <pryzby(at)telsasoft(dot)com>           2019-12-16 02:49:56 from Michael Paquier <michael(at)paquier(dot)xyz>            2019-12-17 11:17:36 from Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>            2019-12-24 01:24:28 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 📎             2019-12-24 04:19:09 from Michael Paquier <michael(at)paquier(dot)xyz> 📎              2019-12-26 08:06:51 from Michael Paquier <michael(at)paquier(dot)xyz>              2019-12-26 15:57:04 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 📎               2019-12-29 00:21:31 from Robert Haas <robertmhaas(at)gmail(dot)com>                2019-12-29 20:17:47 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                 2020-01-06 07:31:43 from Michael Paquier <michael(at)paquier(dot)xyz>               2020-01-02 16:27:01 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 📎                2020-01-20 05:41:59 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 📎                 2020-01-20 19:11:20 from Andres Freund <andres(at)anarazel(dot)de>                  2020-01-20 21:49:29 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 📎                   2020-01-21 06:11:35 from Masahiko Sawada <masahiko(dot)sawada(at)2ndquadrant(dot)com>                    2020-01-21 20:49:33 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 📎                     2020-01-21 20:54:59 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>                      2020-01-22 01:17:52 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 📎                       2020-01-22 02:19:54 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>                       2020-01-22 08:37:06 from Masahiko Sawada <masahiko(dot)sawada(at)2ndquadrant(dot)com>                        2020-01-24 19:21:55 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 📎                   2020-01-26 20:29:38 from Andres Freund <andres(at)anarazel(dot)de>                    2020-01-27 05:38:13 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 📎                     2020-01-27 06:14:38 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                     2020-01-27 06:59:58 from Masahiko Sawada <masahiko(dot)sawada(at)2ndquadrant(dot)com>                      2020-01-27 22:50:18 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 📎                       2020-02-02 01:45:12 from Masahiko Sawada <masahiko(dot)sawada(at)2ndquadrant(dot)com>                        2020-02-02 06:02:59 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 📎                         2020-02-04 04:58:20 from Masahiko Sawada <masahiko(dot)sawada(at)2ndquadrant(dot)com>                          2020-02-08 01:01:07 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 📎                           2020-02-13 05:55:53 from Masahiko Sawada <masahiko(dot)sawada(at)2ndquadrant(dot)com>                            2020-02-13 23:52:54 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 📎                             2020-02-14 03:30:25 from Masahiko Sawada <masahiko(dot)sawada(at)2ndquadrant(dot)com>                              2020-02-14 15:34:12 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 📎                               2020-02-17 01:47:47 from Masahiko Sawada <masahiko(dot)sawada(at)2ndquadrant(dot)com>                                2020-02-17 03:57:31 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 📎                                 2020-02-17 05:18:11 from Masahiko Sawada <masahiko(dot)sawada(at)2ndquadrant(dot)com>                                  2020-02-17 06:14:31 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 📎                                   2020-02-18 09:18:16 from Masahiko Sawada <masahiko(dot)sawada(at)2ndquadrant(dot)com>                                   2020-02-19 20:38:21 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 📎                                    2020-02-20 17:02:36 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>                                     2020-02-20 18:10:26 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                     2020-02-27 21:08:13 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 📎                                      2020-02-28 00:09:42 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>                                       2020-03-03 19:32:05 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 📎                                        2020-03-03 19:49:00 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>                                         2020-03-04 21:53:38 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                                        2020-03-04 07:21:06 from Masahiko Sawada <masahiko(dot)sawada(at)2ndquadrant(dot)com>                                         2020-03-04 21:51:59 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 📎                                          2020-03-16 06:14:25 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                           2020-03-16 14:17:33 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>                                            2020-03-17 03:45:49 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                           2020-03-17 03:51:19 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                                            2020-03-17 04:22:00 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                             2020-03-17 06:21:09 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                              2020-03-19 02:50:51 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                               2020-03-19 04:07:59 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 📎                                                2020-03-19 09:48:32 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> 📎                                                 2020-03-19 20:29:31 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 📎                                                  2020-03-20 00:29:09 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 📎                                                   2020-03-20 05:54:25 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                                    2020-03-20 06:51:20 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 📎                                                     2020-03-20 11:28:08 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> 📎                                                      2020-03-20 14:53:59 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                                                       2020-03-21 07:30:03 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> 📎                                                        2020-03-21 08:03:19 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                                                         2020-03-23 09:41:35 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> 📎                                                        2020-03-23 07:39:54 from Masahiko Sawada <masahiko(dot)sawada(at)2ndquadrant(dot)com>                                                         2020-03-23 08:16:39 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                                                          2020-03-23 08:55:14 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                                           2020-03-24 04:16:16 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                                                            2020-03-24 04:52:49 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                                             2020-03-24 09:07:18 from Masahiko Sawada <masahiko(dot)sawada(at)2ndquadrant(dot)com>                                                              2020-03-24 09:18:51 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                                               2020-03-24 12:47:30 from Masahiko Sawada <masahiko(dot)sawada(at)2ndquadrant(dot)com>                                                                2020-03-24 13:37:03 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                                                 2020-03-24 13:48:49 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                                                                  2020-03-24 14:00:45 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                                                 2020-03-24 14:20:25 from Masahiko Sawada <masahiko(dot)sawada(at)2ndquadrant(dot)com>                                                                  2020-03-25 03:44:42 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                                                   2020-03-25 04:34:43 from Masahiko Sawada <masahiko(dot)sawada(at)2ndquadrant(dot)com>                                                                    2020-03-25 04:46:51 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                                                                    2020-03-25 04:52:21 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                                                     2020-03-25 05:08:19 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                                                                      2020-03-25 05:16:35 from Masahiko Sawada <masahiko(dot)sawada(at)2ndquadrant(dot)com>                                                                       2020-03-25 10:12:29 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 📎                                                                        2020-03-25 11:24:41 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> 📎                                                                         2020-03-25 11:39:17 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                                                                         2020-03-25 12:27:44 from Masahiko Sawada <masahiko(dot)sawada(at)2ndquadrant(dot)com>                                                                          2020-03-25 12:41:55 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                                                                           2020-03-26 04:20:53 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                                                            2020-03-26 04:41:15 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                                                                             2020-03-26 06:33:42 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                                                              2020-03-26 06:34:20 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> 📎                                                                               2020-03-26 11:56:54 from Masahiko Sawada <masahiko(dot)sawada(at)2ndquadrant(dot)com>                                                                                2020-03-26 15:04:57 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                                                                                 2020-03-26 22:17:52 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 📎                                                                                  2020-03-26 22:49:51 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>                                                                                   2020-03-26 23:33:21 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 📎                                                                                    2020-03-27 00:41:21 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>                                                                                    2020-03-30 09:01:53 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> 📎                                                                                     2020-03-30 16:26:16 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 📎                                                                                      2020-03-31 02:20:45 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                                                                       2020-03-31 03:23:08 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                                                                                        2020-04-01 02:24:45 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                                                                         2020-04-01 19:11:15 from Andres Freund <andres(at)anarazel(dot)de>                                                                                          2020-04-01 19:31:53 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>                                                                                  2020-03-27 04:19:29 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                                                                   2020-03-27 04:44:24 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                                                                                    2020-03-27 06:16:01 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                                                                                     2020-03-27 06:20:30 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                                                                      2020-03-27 19:04:29 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                                                                                       2020-03-28 00:58:38 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                                                                        2020-03-28 01:16:32 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                                                                                         2020-03-28 01:29:10 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                                                                          2020-03-28 01:34:34 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                                                                                           2020-03-28 04:22:51 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> 📎                                                                                            2020-03-29 03:33:57 from Masahiko Sawada <masahiko(dot)sawada(at)2ndquadrant(dot)com>                                                                                             2020-03-29 06:05:44 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                                                                              2020-03-30 03:12:46 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                                                                  2020-03-27 07:58:52 from Masahiko Sawada <masahiko(dot)sawada(at)2ndquadrant(dot)com>                                                                                   2020-03-27 08:55:42 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                                                2020-03-25 03:19:22 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 📎                                                                 2020-03-25 03:46:46 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                     2020-03-03 13:05:42 from Masahiko Sawada <masahiko(dot)sawada(at)2ndquadrant(dot)com>                  2020-01-22 23:17:26 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                   2020-01-26 20:25:09 from Andres Freund <andres(at)anarazel(dot)de>                  2020-02-14 01:40:26 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com>       2020-01-20 19:13:05 from Andres Freund <andres(at)anarazel(dot)de>
Lists:	pgsql-hackers

Attachment	Content-Type	Size
v9-0001-dedup2-skip_blocks.patch	text/x-diff	9.1 KB
v9-0002-vacuum-errcontext-to-show-block-being-processed.patch	text/x-diff	3.8 KB
v9-0003-add-errcontext-callback-in-lazy_vacuum_heap-too.patch	text/x-diff	1.9 KB

In response to

• Re: error context for vacuum to include block number at 2020-01-02 16:27:01 from Justin Pryzby

Responses

• Re: error context for vacuum to include block number at 2020-01-20 19:11:20 from Andres Freund

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Paul A Jungwirth	2020-01-20 05:57:57	Re: range_agg
Previous Message	Justin Pryzby	2020-01-20 05:30:14	Re: doc: vacuum full, fillfactor, and "extra space"