Re: ALTER TABLE lock strength reduction patch is unsafe

From:	Peter Geoghegan <pg(at)heroku(dot)com>
To:	Robert Haas <robertmhaas(at)gmail(dot)com>
Cc:	Simon Riggs <simon(at)2ndquadrant(dot)com>, Noah Misch <noah(at)leadboat(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject:	Re: ALTER TABLE lock strength reduction patch is unsafe
Date:	2014-01-27 20:35:58
Message-ID:	CAM3SWZS7ziMoNnSZxLQk=RR955WYUiO7GtG3tKaX5AqYwHk3rQ@mail.gmail.com
Views:	Raw Message | Whole Thread | Download mbox | Resend email
Thread:	2013-07-07 13:24:48 from Simon Riggs <simon(at)2ndQuadrant(dot)com> 📎  2013-07-15 14:06:31 from Robert Haas <robertmhaas(at)gmail(dot)com>   2013-07-15 14:32:10 from Andres Freund <andres(at)2ndquadrant(dot)com>    2013-07-15 15:09:39 from Robert Haas <robertmhaas(at)gmail(dot)com>   2013-07-15 16:50:40 from Simon Riggs <simon(at)2ndQuadrant(dot)com>    2013-08-01 00:53:51 from Noah Misch <noah(at)leadboat(dot)com>     2013-08-01 06:04:14 from Simon Riggs <simon(at)2ndQuadrant(dot)com>     2013-11-13 11:48:15 from Simon Riggs <simon(at)2ndQuadrant(dot)com>     2014-01-15 14:57:53 from Simon Riggs <simon(at)2ndQuadrant(dot)com> 📎      2014-01-24 06:08:33 from Peter Geoghegan <pg(at)heroku(dot)com>       2014-01-24 08:33:32 from Simon Riggs <simon(at)2ndQuadrant(dot)com> 📎        2014-01-27 17:58:02 from Simon Riggs <simon(at)2ndQuadrant(dot)com>         2014-01-27 17:58:42 from Simon Riggs <simon(at)2ndQuadrant(dot)com> 📎         2014-01-27 20:25:22 from Robert Haas <robertmhaas(at)gmail(dot)com>          2014-01-27 20:35:58 from Peter Geoghegan <pg(at)heroku(dot)com>           2014-01-27 20:47:00 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>            2014-01-27 21:08:49 from Simon Riggs <simon(at)2ndQuadrant(dot)com>           2014-01-27 20:57:26 from Simon Riggs <simon(at)2ndQuadrant(dot)com>            2014-01-28 14:55:15 from Bruce Momjian <bruce(at)momjian(dot)us>             2014-01-28 16:36:39 from Simon Riggs <simon(at)2ndQuadrant(dot)com>              2014-01-28 17:15:28 from Bruce Momjian <bruce(at)momjian(dot)us>               2014-01-28 17:21:50 from Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>                2014-01-28 17:26:56 from Bruce Momjian <bruce(at)momjian(dot)us>                 2014-01-28 17:30:47 from Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>                  2014-01-28 17:40:12 from Bruce Momjian <bruce(at)momjian(dot)us>                2014-01-28 17:54:53 from Simon Riggs <simon(at)2ndQuadrant(dot)com>               2014-01-28 17:36:36 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>                2014-01-28 17:42:10 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                2014-01-29 05:04:51 from Robert Haas <robertmhaas(at)gmail(dot)com>                 2014-01-29 05:43:40 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                  2014-01-29 19:54:26 from Simon Riggs <simon(at)2ndQuadrant(dot)com>               2014-01-28 17:47:08 from Simon Riggs <simon(at)2ndQuadrant(dot)com>          2014-01-28 17:46:10 from Andres Freund <andres(at)2ndquadrant(dot)com>        2014-02-24 16:01:26 from Andres Freund <andres(at)2ndquadrant(dot)com>         2014-02-26 07:32:45 from Simon Riggs <simon(at)2ndQuadrant(dot)com>          2014-02-26 13:38:43 from Andres Freund <andres(at)2ndquadrant(dot)com>           2014-02-26 15:15:00 from Simon Riggs <simon(at)2ndQuadrant(dot)com>            2014-02-26 15:25:40 from Andres Freund <andres(at)2ndquadrant(dot)com>             2014-02-27 08:12:47 from Simon Riggs <simon(at)2ndQuadrant(dot)com>              2014-03-03 15:19:55 from Robert Haas <robertmhaas(at)gmail(dot)com>               2014-03-03 15:43:46 from Simon Riggs <simon(at)2ndQuadrant(dot)com>                2014-03-03 15:53:20 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                 2014-03-03 16:22:55 from Simon Riggs <simon(at)2ndQuadrant(dot)com>                2014-03-03 18:58:46 from Noah Misch <noah(at)leadboat(dot)com>               2014-03-03 18:57:36 from Noah Misch <noah(at)leadboat(dot)com>                2014-03-03 19:19:45 from Simon Riggs <simon(at)2ndQuadrant(dot)com>                 2014-03-03 22:42:35 from Noah Misch <noah(at)leadboat(dot)com>                  2014-03-04 00:15:27 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                   2014-03-04 01:07:34 from Andres Freund <andres(at)2ndquadrant(dot)com>                    2014-03-04 01:32:13 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                     2014-03-04 01:45:24 from Andres Freund <andres(at)2ndquadrant(dot)com>                      2014-03-04 02:16:47 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                    2014-03-04 08:31:33 from Simon Riggs <simon(at)2ndQuadrant(dot)com>                     2014-03-04 08:39:28 from Atri Sharma <atri(dot)jiit(at)gmail(dot)com>                      2014-03-04 09:31:14 from Simon Riggs <simon(at)2ndQuadrant(dot)com>                       2014-03-04 09:51:40 from Atri Sharma <atri(dot)jiit(at)gmail(dot)com>                       2014-03-04 11:57:10 from Simon Riggs <simon(at)2ndQuadrant(dot)com>                        2014-03-04 12:18:55 from Robert Haas <robertmhaas(at)gmail(dot)com>                         2014-03-04 13:03:57 from Atri Sharma <atri(dot)jiit(at)gmail(dot)com>                         2014-03-04 13:59:39 from Simon Riggs <simon(at)2ndQuadrant(dot)com>                      2014-03-04 14:49:49 from Stephen Frost <sfrost(at)snowman(dot)net>                       2014-03-04 15:17:52 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>                        2014-03-04 16:25:20 from Robert Haas <robertmhaas(at)gmail(dot)com>                         2014-03-04 16:40:10 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                          2014-03-04 16:45:03 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>                          2014-03-04 17:50:17 from Andres Freund <andres(at)2ndquadrant(dot)com>                           2014-03-04 20:08:37 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                            2014-03-04 22:41:55 from Greg Stark <stark(at)mit(dot)edu>                             2014-03-04 22:46:12 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                           2014-03-06 22:43:40 from Noah Misch <noah(at)leadboat(dot)com>                            2014-03-06 23:49:16 from Simon Riggs <simon(at)2ndQuadrant(dot)com>                            2014-03-07 09:04:04 from Simon Riggs <simon(at)2ndQuadrant(dot)com>                             2014-03-08 11:14:30 from Simon Riggs <simon(at)2ndQuadrant(dot)com> 📎                              2014-03-18 10:39:03 from Simon Riggs <simon(at)2ndQuadrant(dot)com>                               2014-03-18 21:21:22 from Noah Misch <noah(at)leadboat(dot)com>                                2014-03-19 09:52:26 from Simon Riggs <simon(at)2ndQuadrant(dot)com>                               2014-03-20 08:00:50 from Vik Fearing <vik(dot)fearing(at)dalibo(dot)com> 📎                              2014-03-21 03:45:56 from Noah Misch <noah(at)leadboat(dot)com>                               2014-03-21 16:11:12 from Simon Riggs <simon(at)2ndQuadrant(dot)com>                                2014-03-21 17:49:42 from Noah Misch <noah(at)leadboat(dot)com>                                 2014-03-21 18:53:27 from Simon Riggs <simon(at)2ndQuadrant(dot)com>                                  2014-03-21 20:58:28 from Noah Misch <noah(at)leadboat(dot)com>                                   2014-03-21 21:23:30 from Simon Riggs <simon(at)2ndQuadrant(dot)com>                                    2014-03-21 23:36:28 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                     2014-03-22 07:31:00 from Simon Riggs <simon(at)2ndQuadrant(dot)com>                                2014-03-22 07:36:02 from Simon Riggs <simon(at)2ndQuadrant(dot)com>                               2014-03-21 19:11:14 from Simon Riggs <simon(at)2ndQuadrant(dot)com>                        2014-03-04 16:27:20 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                         2014-03-04 16:38:37 from Stephen Frost <sfrost(at)snowman(dot)net>                          2014-03-04 16:46:10 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                           2014-03-04 16:50:22 from Stephen Frost <sfrost(at)snowman(dot)net>                            2014-03-04 17:21:14 from Atri Sharma <atri(dot)jiit(at)gmail(dot)com>                         2014-03-04 19:39:55 from Simon Riggs <simon(at)2ndQuadrant(dot)com>                          2014-03-04 19:43:08 from Andres Freund <andres(at)2ndquadrant(dot)com>                           2014-03-04 22:29:31 from Josh Berkus <josh(at)agliodbs(dot)com>                            2014-03-04 22:39:01 from Andres Freund <andres(at)2ndquadrant(dot)com>                          2014-03-04 20:54:24 from Robert Haas <robertmhaas(at)gmail(dot)com>                           2014-03-04 21:37:48 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                            2014-03-04 22:43:55 from Andres Freund <andres(at)2ndquadrant(dot)com>                             2014-03-04 22:53:59 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                            2014-03-05 09:28:44 from Simon Riggs <simon(at)2ndQuadrant(dot)com> 📎                             2014-03-06 09:47:04 from Simon Riggs <simon(at)2ndQuadrant(dot)com>                              2014-03-10 00:52:26 from Vik Fearing <vik(dot)fearing(at)dalibo(dot)com>                       2014-03-04 15:49:46 from Atri Sharma <atri(dot)jiit(at)gmail(dot)com>             2014-02-27 08:48:46 from Simon Riggs <simon(at)2ndQuadrant(dot)com> 📎              2014-03-01 11:06:27 from Simon Riggs <simon(at)2ndQuadrant(dot)com> 📎               2014-03-01 21:25:29 from Vik Fearing <vik(dot)fearing(at)dalibo(dot)com> 📎                2014-03-02 09:50:41 from Simon Riggs <simon(at)2ndQuadrant(dot)com> 📎                 2014-03-03 16:06:45 from Robert Haas <robertmhaas(at)gmail(dot)com>                  2014-03-03 16:29:16 from Simon Riggs <simon(at)2ndQuadrant(dot)com>                   2014-03-03 16:36:16 from Robert Haas <robertmhaas(at)gmail(dot)com>                    2014-03-03 21:18:20 from Simon Riggs <simon(at)2ndQuadrant(dot)com> 📎            2014-03-22 16:37:27 from Jim Nasby <jim(at)nasby(dot)net>          2014-02-27 08:06:32 from Simon Riggs <simon(at)2ndQuadrant(dot)com>  2014-01-14 17:36:56 from Simon Riggs <simon(at)2ndQuadrant(dot)com> 📎
Lists:	pgsql-hackers

In response to

• Re: ALTER TABLE lock strength reduction patch is unsafe at 2014-01-27 20:25:22 from Robert Haas

Responses

• Re: ALTER TABLE lock strength reduction patch is unsafe at 2014-01-27 20:47:00 from Tom Lane
• Re: ALTER TABLE lock strength reduction patch is unsafe at 2014-01-27 20:57:26 from Simon Riggs

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Tom Lane	2014-01-27 20:38:03	pgsql: Keep pg_stat_statements' query texts in a file, not in shared me
Previous Message	Robert Haas	2014-01-27 20:25:22	Re: ALTER TABLE lock strength reduction patch is unsafe