Re: New strategies for freezing, advancing relfrozenxid early

From:	Justin Pryzby <pryzby(at)telsasoft(dot)com>
To:	Peter Geoghegan <pg(at)bowt(dot)ie>
Cc:	Andres Freund <andres(at)anarazel(dot)de>, Jeff Davis <pgsql(at)j-davis(dot)com>, pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject:	Re: New strategies for freezing, advancing relfrozenxid early
Date:	2022-12-15 19:11:14
Message-ID:	20221215191114.GJ1153@telsasoft.com
Views:	Raw Message | Whole Thread | Download mbox | Resend email
Thread:	2022-08-25 21:21:12 from Peter Geoghegan <pg(at)bowt(dot)ie> 📎  2022-08-25 22:35:17 from Jeremy Schneider <schnjere(at)amazon(dot)com>   2022-08-25 23:23:09 from Peter Geoghegan <pg(at)bowt(dot)ie>    2022-08-26 00:14:51 from Peter Geoghegan <pg(at)bowt(dot)ie>  2022-08-29 18:47:16 from Jeff Davis <pgsql(at)j-davis(dot)com>   2022-08-29 20:27:42 from Peter Geoghegan <pg(at)bowt(dot)ie>  2022-08-30 18:11:41 from Jeff Davis <pgsql(at)j-davis(dot)com>   2022-08-30 20:45:19 from Peter Geoghegan <pg(at)bowt(dot)ie>    2022-08-31 01:50:49 from Peter Geoghegan <pg(at)bowt(dot)ie>     2022-08-31 04:37:20 from Jeff Davis <pgsql(at)j-davis(dot)com>      2022-08-31 05:12:57 from Peter Geoghegan <pg(at)bowt(dot)ie>    2022-08-31 06:28:46 from Jeff Davis <pgsql(at)j-davis(dot)com>     2022-08-31 07:03:02 from Peter Geoghegan <pg(at)bowt(dot)ie>      2022-09-08 20:23:52 from Peter Geoghegan <pg(at)bowt(dot)ie> 📎       2022-09-13 17:53:06 from Peter Geoghegan <pg(at)bowt(dot)ie> 📎        2022-09-14 10:18:08 from John Naylor <john(dot)naylor(at)enterprisedb(dot)com>         2022-09-14 16:33:17 from Peter Geoghegan <pg(at)bowt(dot)ie>          2022-09-15 07:09:44 from John Naylor <john(dot)naylor(at)enterprisedb(dot)com>           2022-09-15 17:59:55 from Peter Geoghegan <pg(at)bowt(dot)ie>       2022-10-04 00:41:56 from Jeff Davis <pgsql(at)j-davis(dot)com>        2022-10-04 03:11:20 from Peter Geoghegan <pg(at)bowt(dot)ie>         2022-10-04 05:13:24 from Jeff Davis <pgsql(at)j-davis(dot)com>          2022-10-04 05:45:37 from Peter Geoghegan <pg(at)bowt(dot)ie>           2022-10-04 17:39:31 from Jeff Davis <pgsql(at)j-davis(dot)com>            2022-10-04 18:09:31 from Peter Geoghegan <pg(at)bowt(dot)ie>             2022-10-05 02:59:49 from Jeff Davis <pgsql(at)j-davis(dot)com>              2022-10-05 04:00:46 from Peter Geoghegan <pg(at)bowt(dot)ie>       2022-10-17 23:52:11 from Peter Geoghegan <pg(at)bowt(dot)ie> 📎        2022-11-11 03:44:55 from Justin Pryzby <pryzby(at)telsasoft(dot)com>         2022-11-16 03:02:12 from Peter Geoghegan <pg(at)bowt(dot)ie> 📎          2022-11-16 05:20:23 from Andres Freund <andres(at)anarazel(dot)de>           2022-11-19 01:06:57 from Peter Geoghegan <pg(at)bowt(dot)ie> 📎            2022-11-23 23:06:52 from Peter Geoghegan <pg(at)bowt(dot)ie> 📎             2022-12-06 18:42:55 from Andres Freund <andres(at)anarazel(dot)de>              2022-12-06 21:45:09 from Peter Geoghegan <pg(at)bowt(dot)ie>               2022-12-11 02:11:21 from Peter Geoghegan <pg(at)bowt(dot)ie> 📎                2022-12-12 23:47:16 from Jeff Davis <pgsql(at)j-davis(dot)com>                 2022-12-13 00:59:58 from Peter Geoghegan <pg(at)bowt(dot)ie>                  2022-12-13 08:29:18 from John Naylor <john(dot)naylor(at)enterprisedb(dot)com>                   2022-12-13 17:16:19 from Peter Geoghegan <pg(at)bowt(dot)ie>                    2022-12-13 23:07:10 from Peter Geoghegan <pg(at)bowt(dot)ie>                     2022-12-15 14:50:19 from Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com>                      2022-12-15 18:53:04 from Peter Geoghegan <pg(at)bowt(dot)ie>                       2022-12-18 22:20:49 from Peter Geoghegan <pg(at)bowt(dot)ie> 📎                        2022-12-20 09:01:49 from Jeff Davis <pgsql(at)j-davis(dot)com>                         2022-12-20 18:04:14 from Nikita Malakhov <hukutoc(at)gmail(dot)com>                        2022-12-21 01:44:27 from Jeff Davis <pgsql(at)j-davis(dot)com>                         2022-12-21 03:15:33 from Peter Geoghegan <pg(at)bowt(dot)ie>                          2022-12-21 05:26:21 from Peter Geoghegan <pg(at)bowt(dot)ie>                           2022-12-22 00:30:28 from Jeff Davis <pgsql(at)j-davis(dot)com>                            2022-12-22 00:53:48 from Peter Geoghegan <pg(at)bowt(dot)ie>                             2022-12-22 19:39:10 from Peter Geoghegan <pg(at)bowt(dot)ie> 📎                              2022-12-26 20:53:52 from Peter Geoghegan <pg(at)bowt(dot)ie> 📎                               2022-12-27 06:57:47 from "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com>                                2022-12-27 07:30:25 from Peter Geoghegan <pg(at)bowt(dot)ie>                                 2022-12-27 07:47:52 from "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com>                               2022-12-28 17:34:02 from Peter Geoghegan <pg(at)bowt(dot)ie> 📎                               2022-12-30 20:43:04 from Jeff Davis <pgsql(at)j-davis(dot)com>                                2022-12-30 21:12:21 from Peter Geoghegan <pg(at)bowt(dot)ie>                                 2022-12-31 00:58:12 from Peter Geoghegan <pg(at)bowt(dot)ie>                                  2022-12-31 19:46:15 from Jeff Davis <pgsql(at)j-davis(dot)com>                                   2022-12-31 20:45:26 from Peter Geoghegan <pg(at)bowt(dot)ie>                                    2023-01-02 19:45:11 from Peter Geoghegan <pg(at)bowt(dot)ie> 📎                                     2023-01-03 02:26:13 from Jeff Davis <pgsql(at)j-davis(dot)com>                                      2023-01-03 20:30:02 from Peter Geoghegan <pg(at)bowt(dot)ie> 📎                                       2023-01-05 01:21:37 from Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com>                                        2023-01-05 18:19:07 from Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com>                                         2023-01-06 23:28:16 from Peter Geoghegan <pg(at)bowt(dot)ie>                                        2023-01-06 23:07:04 from Peter Geoghegan <pg(at)bowt(dot)ie>                                       2023-01-09 01:45:41 from Peter Geoghegan <pg(at)bowt(dot)ie> 📎                                        2023-01-16 05:12:56 from Dilip Kumar <dilipbalaut(at)gmail(dot)com>                                         2023-01-16 18:00:52 from Peter Geoghegan <pg(at)bowt(dot)ie>                                          2023-01-17 02:24:53 from Peter Geoghegan <pg(at)bowt(dot)ie>                                          2023-01-17 04:13:12 from Dilip Kumar <dilipbalaut(at)gmail(dot)com>                                           2023-01-17 04:35:05 from Peter Geoghegan <pg(at)bowt(dot)ie>                                            2023-01-18 08:17:44 from Dilip Kumar <dilipbalaut(at)gmail(dot)com>                                             2023-01-23 11:17:09 from Dilip Kumar <dilipbalaut(at)gmail(dot)com>                                              2023-01-23 18:01:27 from Peter Geoghegan <pg(at)bowt(dot)ie>                                        2023-01-16 18:10:25 from Peter Geoghegan <pg(at)bowt(dot)ie> 📎                                         2023-01-17 01:55:49 from Peter Geoghegan <pg(at)bowt(dot)ie>                                          2023-01-24 22:49:38 from Peter Geoghegan <pg(at)bowt(dot)ie> 📎                                           2023-01-25 15:51:33 from Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com>                                           2023-01-26 00:43:47 from Andres Freund <andres(at)anarazel(dot)de>                                            2023-01-26 01:22:32 from Peter Geoghegan <pg(at)bowt(dot)ie>                                             2023-01-26 01:49:28 from Andres Freund <andres(at)anarazel(dot)de>                                              2023-01-26 02:31:16 from Peter Geoghegan <pg(at)bowt(dot)ie>                                               2023-01-26 03:10:59 from Andres Freund <andres(at)anarazel(dot)de>                                                2023-01-26 03:48:05 from Peter Geoghegan <pg(at)bowt(dot)ie>                                                2023-01-26 04:12:22 from John Naylor <john(dot)naylor(at)enterprisedb(dot)com>                                                 2023-01-26 04:36:11 from Peter Geoghegan <pg(at)bowt(dot)ie>                                              2023-01-26 03:41:15 from Robert Haas <robertmhaas(at)gmail(dot)com>                                               2023-01-26 04:24:35 from Peter Geoghegan <pg(at)bowt(dot)ie>                                                2023-01-26 06:38:49 from Peter Geoghegan <pg(at)bowt(dot)ie>                                                2023-01-26 13:41:06 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                 2023-01-26 16:35:04 from Peter Geoghegan <pg(at)bowt(dot)ie>                                                  2023-01-26 19:27:53 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                   2023-01-26 19:56:35 from Peter Geoghegan <pg(at)bowt(dot)ie>                                                    2023-01-26 20:54:17 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                     2023-01-26 21:06:31 from Peter Geoghegan <pg(at)bowt(dot)ie>                                                      2023-01-26 21:21:54 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                       2023-01-26 21:51:03 from Peter Geoghegan <pg(at)bowt(dot)ie>                                                        2023-01-27 14:48:43 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                         2023-01-27 16:22:23 from Peter Geoghegan <pg(at)bowt(dot)ie>                                                   2023-01-27 01:15:10 from Andres Freund <andres(at)anarazel(dot)de>                                            2023-01-26 01:26:33 from Andres Freund <andres(at)anarazel(dot)de>                                             2023-01-26 01:37:17 from Peter Geoghegan <pg(at)bowt(dot)ie>                                              2023-01-26 01:56:56 from Andres Freund <andres(at)anarazel(dot)de>                                           2023-01-26 01:15:00 from Andres Freund <andres(at)anarazel(dot)de>                                            2023-01-26 01:28:48 from Peter Geoghegan <pg(at)bowt(dot)ie>                                             2023-01-26 02:33:06 from Andres Freund <andres(at)anarazel(dot)de>                                              2023-01-26 02:43:10 from Peter Geoghegan <pg(at)bowt(dot)ie>                                               2023-01-26 03:56:08 from Andres Freund <andres(at)anarazel(dot)de>                                                2023-01-26 14:20:57 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                 2023-01-26 16:35:45 from Andres Freund <andres(at)anarazel(dot)de>                                                  2023-01-26 16:54:55 from Peter Geoghegan <pg(at)bowt(dot)ie>                                                   2023-01-26 17:53:34 from Andres Freund <andres(at)anarazel(dot)de>                                                    2023-01-26 18:44:45 from Peter Geoghegan <pg(at)bowt(dot)ie>                                                     2023-01-26 19:26:00 from Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com>                                                      2023-01-26 20:32:01 from Peter Geoghegan <pg(at)bowt(dot)ie>                                                      2023-01-26 20:55:10 from Andres Freund <andres(at)anarazel(dot)de>                                                     2023-01-26 20:45:14 from Andres Freund <andres(at)anarazel(dot)de>                                                      2023-01-26 23:36:52 from Peter Geoghegan <pg(at)bowt(dot)ie>                                                       2023-01-27 02:37:43 from Andres Freund <andres(at)anarazel(dot)de>                                                        2023-01-27 03:01:03 from Peter Geoghegan <pg(at)bowt(dot)ie>                                                         2023-01-27 05:58:05 from Andres Freund <andres(at)anarazel(dot)de>                                                          2023-01-27 07:11:41 from Peter Geoghegan <pg(at)bowt(dot)ie>                                                           2023-01-27 08:51:59 from Andres Freund <andres(at)anarazel(dot)de>                                                            2023-01-27 09:02:53 from Andres Freund <andres(at)anarazel(dot)de>                                                            2023-01-27 18:40:10 from Peter Geoghegan <pg(at)bowt(dot)ie>                                                          2023-01-27 17:53:58 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                           2023-01-27 18:36:22 from Andres Freund <andres(at)anarazel(dot)de>                                                       2023-01-27 14:53:29 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                2023-01-26 16:24:21 from Peter Geoghegan <pg(at)bowt(dot)ie>                     2022-12-16 07:48:17 from John Naylor <john(dot)naylor(at)enterprisedb(dot)com>                      2022-12-16 07:59:39 from Nikita Malakhov <hukutoc(at)gmail(dot)com>                       2022-12-17 02:44:11 from Peter Geoghegan <pg(at)bowt(dot)ie>                      2022-12-16 21:53:56 from Peter Geoghegan <pg(at)bowt(dot)ie>                2022-12-15 19:11:14 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                 2022-12-16 04:13:07 from Peter Geoghegan <pg(at)bowt(dot)ie>  2022-08-31 22:05:52 from Peter Geoghegan <pg(at)bowt(dot)ie> 📎
Lists:	pgsql-hackers

In response to

• Re: New strategies for freezing, advancing relfrozenxid early at 2022-12-11 02:11:21 from Peter Geoghegan

Responses

• Re: New strategies for freezing, advancing relfrozenxid early at 2022-12-16 04:13:07 from Peter Geoghegan

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Nathan Bossart	2022-12-15 19:12:46	Re: allow granting CLUSTER, REFRESH MATERIALIZED VIEW, and REINDEX
Previous Message	Tom Lane	2022-12-15 18:56:30	Re: BUG #17717: Regression in vacuumdb (15 is slower than 10/11 and possible memory issue)