Re: Expanding HOT updates for expression and partial indexes

From:	"Greg Burd" <greg(at)burd(dot)me>
To:	"Jeff Davis" <pgsql(at)j-davis(dot)com>
Cc:	pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject:	Re: Expanding HOT updates for expression and partial indexes
Date:	2026-02-26 23:01:53
Message-ID:	bed3fd08-ebfd-4980-801e-bff245a27dd7@app.fastmail.com
Views:	Whole Thread | Raw Message | Download mbox | Resend email
Thread:	2025-02-06 22:24:34 from "Burd, Greg" <gregburd(at)amazon(dot)com> 📎  2025-02-09 06:14:49 from Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>   2025-02-10 12:02:27 from "Burd, Greg" <gregburd(at)amazon(dot)com>  2025-02-10 17:17:42 from Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com>   2025-02-10 18:15:50 from "Burd, Greg" <gregburd(at)amazon(dot)com>    2025-02-11 21:40:41 from Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com>     2025-02-12 15:33:52 from "Burd, Greg" <gregburd(at)amazon(dot)com>   2025-02-10 19:11:13 from "Burd, Greg" <gregburd(at)amazon(dot)com>    2025-02-11 21:18:45 from Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com> 📎     2025-02-13 18:46:18 from "Burd, Greg" <gregburd(at)amazon(dot)com> 📎      2025-02-15 10:49:47 from Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com>       2025-02-17 19:53:47 from "Burd, Greg" <gregburd(at)amazon(dot)com> 📎        2025-02-18 18:09:22 from "Burd, Greg" <gregburd(at)amazon(dot)com> 📎         2025-03-05 17:20:34 from "Burd, Greg" <gregburd(at)amazon(dot)com> 📎          2025-03-05 23:39:03 from Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com>           2025-03-06 12:40:22 from "Burd, Greg" <gregburd(at)amazon(dot)com>            2025-03-07 22:47:45 from Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com>             2025-03-25 11:47:21 from "Burd, Greg" <gregburd(at)amazon(dot)com> 📎              2025-03-25 14:21:14 from "Burd, Greg" <gregburd(at)amazon(dot)com> 📎               2025-07-02 18:10:19 from "Greg Burd" <greg(at)burd(dot)me> 📎                2025-10-07 21:36:11 from Greg Burd <greg(at)burd(dot)me> 📎                 2025-10-08 20:48:46 from Nathan Bossart <nathandbossart(at)gmail(dot)com>                  2025-10-09 19:08:30 from Jeff Davis <pgsql(at)j-davis(dot)com>                   2025-10-09 21:13:12 from Greg Burd <greg(at)burd(dot)me>                  2025-10-09 20:57:07 from Greg Burd <greg(at)burd(dot)me>                 2025-10-09 19:27:15 from Jeff Davis <pgsql(at)j-davis(dot)com>                  2025-10-14 17:46:01 from Greg Burd <greg(at)burd(dot)me>                   2025-10-14 18:43:09 from Jeff Davis <pgsql(at)j-davis(dot)com>                  2025-11-16 18:53:09 from Greg Burd <greg(at)burd(dot)me> 📎                   2025-11-19 18:00:29 from Greg Burd <greg(at)burd(dot)me> 📎                    2025-11-19 18:21:51 from Greg Burd <greg(at)burd(dot)me> 📎                    2025-11-21 15:25:06 from Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com>                     2025-11-22 21:30:39 from Greg Burd <greg(at)burd(dot)me> 📎                      2025-11-24 18:59:10 from Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com>                       2025-12-03 22:06:06 from Greg Burd <greg(at)burd(dot)me> 📎                        2025-12-15 21:46:11 from Greg Burd <greg(at)burd(dot)me> 📎                         2026-01-08 20:25:55 from Greg Burd <greg(at)burd(dot)me> 📎                          2026-01-13 14:54:10 from Greg Burd <greg(at)burd(dot)me> 📎                           2026-02-10 15:09:36 from "Greg Burd" <greg(at)burd(dot)me> 📎                            2026-02-13 21:06:08 from "Greg Burd" <greg(at)burd(dot)me> 📎                             2026-02-14 19:39:53 from Jeff Davis <pgsql(at)j-davis(dot)com>                              2026-02-15 20:39:42 from "Greg Burd" <greg(at)burd(dot)me> 📎                               2026-02-16 19:36:36 from Jeff Davis <pgsql(at)j-davis(dot)com>                                2026-02-17 21:15:02 from "Greg Burd" <greg(at)burd(dot)me> 📎                                 2026-02-19 20:32:25 from "Greg Burd" <greg(at)burd(dot)me> 📎                                 2026-02-19 20:43:04 from Andres Freund <andres(at)anarazel(dot)de>                                  2026-02-19 22:31:12 from "Greg Burd" <greg(at)burd(dot)me>                                   2026-02-23 19:23:39 from "Greg Burd" <greg(at)burd(dot)me> 📎                                    2026-02-25 21:03:01 from Jeff Davis <pgsql(at)j-davis(dot)com>                                     2026-02-26 22:08:17 from "Greg Burd" <greg(at)burd(dot)me> 📎                                      2026-02-26 23:01:53 from "Greg Burd" <greg(at)burd(dot)me> 📎                                       2026-03-02 19:08:50 from "Greg Burd" <greg(at)burd(dot)me> 📎        2025-03-05 22:56:42 from Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com>         2025-03-06 12:22:58 from "Burd, Greg" <gregburd(at)amazon(dot)com>   2025-02-10 23:20:41 from Nathan Bossart <nathandbossart(at)gmail(dot)com>    2025-02-11 18:03:11 from Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com>
Lists:	pgsql-hackers

Attachment	Content-Type	Size
v31-0001-Idenfity-modified-indexed-attributes-in-the-exec.patch	text/x-patch	57.2 KB

In response to

• Re: Expanding HOT updates for expression and partial indexes at 2026-02-26 22:08:17 from Greg Burd

Responses

• Re: Expanding HOT updates for expression and partial indexes at 2026-03-02 19:08:50 from Greg Burd

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Fujii Masao	2026-02-26 23:09:46	Re: Show comments in \dRp+, \dRs+, and \dX+ psql meta-commands
Previous Message	Tom Lane	2026-02-26 22:14:43	Re: Show expression of virtual columns in error messages