Re: Emit fewer vacuum records by reaping removable tuples during pruning

From:	Robert Haas <robertmhaas(at)gmail(dot)com>
To:	Andres Freund <andres(at)anarazel(dot)de>
Cc:	Melanie Plageman <melanieplageman(at)gmail(dot)com>, Michael Paquier <michael(at)paquier(dot)xyz>, Peter Geoghegan <pg(at)bowt(dot)ie>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject:	Re: Emit fewer vacuum records by reaping removable tuples during pruning
Date:	2024-01-11 18:43:27
Message-ID:	CA+TgmoY43B=XuWq9fWu2Hdvgtt1q+RerrvoCQFsV24_o-LFh6g@mail.gmail.com
Views:	Raw Message | Whole Thread | Download mbox | Resend email
Thread:	2023-11-13 22:28:50 from Melanie Plageman <melanieplageman(at)gmail(dot)com> 📎  2023-11-13 22:58:44 from Peter Geoghegan <pg(at)bowt(dot)ie>   2023-11-14 00:06:15 from Melanie Plageman <melanieplageman(at)gmail(dot)com>    2023-12-24 02:14:05 from Michael Paquier <michael(at)paquier(dot)xyz>     2023-12-27 16:26:52 from Melanie Plageman <melanieplageman(at)gmail(dot)com>      2024-01-04 17:31:36 from Robert Haas <robertmhaas(at)gmail(dot)com>       2024-01-04 19:24:20 from Andres Freund <andres(at)anarazel(dot)de>       2024-01-04 23:03:25 from Melanie Plageman <melanieplageman(at)gmail(dot)com>        2024-01-05 13:59:41 from Robert Haas <robertmhaas(at)gmail(dot)com>         2024-01-05 17:59:34 from Melanie Plageman <melanieplageman(at)gmail(dot)com>          2024-01-05 18:47:43 from Robert Haas <robertmhaas(at)gmail(dot)com>           2024-01-05 20:34:22 from Melanie Plageman <melanieplageman(at)gmail(dot)com> 📎            2024-01-08 20:50:47 from Robert Haas <robertmhaas(at)gmail(dot)com>             2024-01-09 05:56:34 from Michael Paquier <michael(at)paquier(dot)xyz>              2024-01-09 15:56:46 from Melanie Plageman <melanieplageman(at)gmail(dot)com>               2024-01-09 18:31:30 from Robert Haas <robertmhaas(at)gmail(dot)com>                2024-01-09 19:23:24 from Melanie Plageman <melanieplageman(at)gmail(dot)com>                 2024-01-09 19:33:29 from Robert Haas <robertmhaas(at)gmail(dot)com>                  2024-01-09 19:35:36 from Andres Freund <andres(at)anarazel(dot)de>                   2024-01-11 18:43:27 from Robert Haas <robertmhaas(at)gmail(dot)com>                    2024-01-12 04:35:40 from Michael Paquier <michael(at)paquier(dot)xyz>             2024-01-09 16:35:34 from Melanie Plageman <melanieplageman(at)gmail(dot)com>              2024-01-09 19:00:27 from Robert Haas <robertmhaas(at)gmail(dot)com>               2024-01-09 20:13:30 from Melanie Plageman <melanieplageman(at)gmail(dot)com> 📎                2024-01-09 20:40:36 from Robert Haas <robertmhaas(at)gmail(dot)com>                 2024-01-09 22:42:38 from Melanie Plageman <melanieplageman(at)gmail(dot)com> 📎                  2024-01-10 20:54:40 from Robert Haas <robertmhaas(at)gmail(dot)com>                   2024-01-10 22:27:57 from Melanie Plageman <melanieplageman(at)gmail(dot)com>                    2024-01-11 16:54:32 from Robert Haas <robertmhaas(at)gmail(dot)com>                     2024-01-11 19:30:07 from Melanie Plageman <melanieplageman(at)gmail(dot)com> 📎                      2024-01-11 21:49:01 from Robert Haas <robertmhaas(at)gmail(dot)com>                       2024-01-12 02:04:59 from Melanie Plageman <melanieplageman(at)gmail(dot)com>                        2024-01-12 14:43:53 from Robert Haas <robertmhaas(at)gmail(dot)com>                         2024-01-12 16:50:00 from Peter Geoghegan <pg(at)bowt(dot)ie>                          2024-01-12 17:33:28 from Melanie Plageman <melanieplageman(at)gmail(dot)com>                           2024-01-12 18:07:30 from Peter Geoghegan <pg(at)bowt(dot)ie>                            2024-01-12 18:52:14 from Melanie Plageman <melanieplageman(at)gmail(dot)com>                             2024-01-12 19:32:13 from Robert Haas <robertmhaas(at)gmail(dot)com> 📎                              2024-01-12 19:43:09 from Peter Geoghegan <pg(at)bowt(dot)ie>                               2024-01-12 19:47:11 from Robert Haas <robertmhaas(at)gmail(dot)com>                                2024-01-12 20:04:19 from Melanie Plageman <melanieplageman(at)gmail(dot)com>                                 2024-01-12 20:22:16 from Robert Haas <robertmhaas(at)gmail(dot)com>                                  2024-01-12 21:05:35 from Melanie Plageman <melanieplageman(at)gmail(dot)com>                                   2024-01-15 17:29:57 from Robert Haas <robertmhaas(at)gmail(dot)com> 📎                                    2024-01-15 21:03:24 from Melanie Plageman <melanieplageman(at)gmail(dot)com>                                     2024-01-16 15:24:27 from Robert Haas <robertmhaas(at)gmail(dot)com> 📎                                      2024-01-16 16:28:46 from Melanie Plageman <melanieplageman(at)gmail(dot)com>                                       2024-01-16 19:23:07 from Robert Haas <robertmhaas(at)gmail(dot)com>                                        2024-01-16 23:07:24 from Melanie Plageman <melanieplageman(at)gmail(dot)com> 📎                                         2024-01-17 17:17:09 from Robert Haas <robertmhaas(at)gmail(dot)com>                                          2024-01-17 20:11:55 from Melanie Plageman <melanieplageman(at)gmail(dot)com> 📎                                           2024-01-17 20:58:10 from Robert Haas <robertmhaas(at)gmail(dot)com>                                            2024-01-17 21:25:02 from Peter Geoghegan <pg(at)bowt(dot)ie>                                             2024-01-17 21:31:12 from Peter Geoghegan <pg(at)bowt(dot)ie>                                              2024-01-17 22:47:37 from Melanie Plageman <melanieplageman(at)gmail(dot)com>                                               2024-01-17 23:08:51 from Peter Geoghegan <pg(at)bowt(dot)ie>                                              2024-01-18 13:51:46 from Robert Haas <robertmhaas(at)gmail(dot)com>                                               2024-01-18 15:09:11 from Peter Geoghegan <pg(at)bowt(dot)ie>                                                2024-01-18 15:42:53 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                 2024-01-18 15:50:13 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                 2024-01-18 16:17:21 from Peter Geoghegan <pg(at)bowt(dot)ie>                                                  2024-01-18 16:45:53 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                   2024-01-18 17:14:55 from Peter Geoghegan <pg(at)bowt(dot)ie>                                                    2024-01-18 17:38:13 from Robert Haas <robertmhaas(at)gmail(dot)com>                                             2024-01-17 22:38:52 from Melanie Plageman <melanieplageman(at)gmail(dot)com>                                            2024-01-17 22:33:27 from Melanie Plageman <melanieplageman(at)gmail(dot)com>                                             2024-01-18 14:53:12 from Melanie Plageman <melanieplageman(at)gmail(dot)com> 📎                                              2024-01-18 15:09:28 from Robert Haas <robertmhaas(at)gmail(dot)com>                                               2024-01-18 20:20:38 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                2024-01-19 02:23:44 from Melanie Plageman <melanieplageman(at)gmail(dot)com> 📎                                                 2024-01-24 19:59:44 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                  2024-01-24 21:34:11 from Melanie Plageman <melanieplageman(at)gmail(dot)com>                                                   2024-01-25 02:13:09 from Melanie Plageman <melanieplageman(at)gmail(dot)com> 📎                                                    2024-01-25 02:26:12 from Peter Geoghegan <pg(at)bowt(dot)ie>                                                    2024-01-25 13:56:54 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                     2024-01-25 14:17:47 from Melanie Plageman <melanieplageman(at)gmail(dot)com>                                                      2024-01-25 15:19:28 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                       2024-01-25 16:18:55 from Melanie Plageman <melanieplageman(at)gmail(dot)com>                                                        2024-01-25 17:25:46 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                         2024-01-26 16:44:01 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                          2024-01-26 17:06:30 from Melanie Plageman <melanieplageman(at)gmail(dot)com>                                                          2024-01-26 18:05:48 from Peter Geoghegan <pg(at)bowt(dot)ie>                             2024-01-12 20:01:59 from Peter Geoghegan <pg(at)bowt(dot)ie>                            2024-01-12 19:02:21 from Melanie Plageman <melanieplageman(at)gmail(dot)com>                          2024-01-12 18:45:53 from Robert Haas <robertmhaas(at)gmail(dot)com>                           2024-01-16 21:28:32 from Jim Nasby <jim(dot)nasby(at)gmail(dot)com>                            2024-01-16 21:59:17 from Robert Haas <robertmhaas(at)gmail(dot)com>                         2024-01-12 17:03:05 from Melanie Plageman <melanieplageman(at)gmail(dot)com>          2024-01-08 17:27:16 from Peter Geoghegan <pg(at)bowt(dot)ie>         2024-01-05 20:05:20 from Andres Freund <andres(at)anarazel(dot)de>          2024-01-05 20:23:12 from Robert Haas <robertmhaas(at)gmail(dot)com>           2024-01-05 20:57:30 from Andres Freund <andres(at)anarazel(dot)de>            2024-01-06 16:34:25 from Peter Geoghegan <pg(at)bowt(dot)ie>            2024-01-08 20:10:33 from Robert Haas <robertmhaas(at)gmail(dot)com>             2024-01-09 21:20:01 from Jim Nasby <jim(dot)nasby(at)gmail(dot)com>           2024-01-06 16:03:03 from Peter Geoghegan <pg(at)bowt(dot)ie>  2023-11-17 23:12:08 from Melanie Plageman <melanieplageman(at)gmail(dot)com> 📎   2023-12-21 21:36:12 from Melanie Plageman <melanieplageman(at)gmail(dot)com>   2024-01-04 20:03:31 from Andres Freund <andres(at)anarazel(dot)de>    2024-01-04 22:37:27 from Melanie Plageman <melanieplageman(at)gmail(dot)com>     2024-01-05 19:47:09 from Andres Freund <andres(at)anarazel(dot)de>      2024-01-05 23:57:02 from Melanie Plageman <melanieplageman(at)gmail(dot)com>    2024-01-06 15:34:59 from Melanie Plageman <melanieplageman(at)gmail(dot)com> 📎
Lists:	pgsql-hackers

In response to

• Re: Emit fewer vacuum records by reaping removable tuples during pruning at 2024-01-09 19:35:36 from Andres Freund

Responses

• Re: Emit fewer vacuum records by reaping removable tuples during pruning at 2024-01-12 04:35:40 from Michael Paquier

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Robert Haas	2024-01-11 18:49:12	Re: pgsql: Add new pg_walsummary tool.
Previous Message	Robert Haas	2024-01-11 18:13:24	Re: cleanup patches for incremental backup