Re: [HACKERS] Re: pgsql: Avoid extra locks in GetSnapshotData if old_snapshot_threshold <

From:	Andres Freund <andres(at)anarazel(dot)de>
To:	Kevin Grittner <kgrittn(at)gmail(dot)com>
Cc:	Robert Haas <robertmhaas(at)gmail(dot)com>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Ants Aasma <ants(dot)aasma(at)eesti(dot)ee>, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, Noah Misch <noah(at)leadboat(dot)com>, Kevin Grittner <kgrittn(at)postgresql(dot)org>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>, "pgsql-committers(at)postgresql(dot)org" <pgsql-committers(at)postgresql(dot)org>
Subject:	Re: [HACKERS] Re: pgsql: Avoid extra locks in GetSnapshotData if old_snapshot_threshold <
Date:	2016-06-16 19:01:34
Message-ID:	20160616190134.7uooo423uov66gqu@alap3.anarazel.de
Views:	Raw Message | Whole Thread | Download mbox | Resend email
Thread:	2016-04-12 16:49:25 from Kevin Grittner <kgrittn(at)postgresql(dot)org>  2016-04-12 17:08:04 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>   2016-04-12 17:22:01 from Kevin Grittner <kgrittn(at)gmail(dot)com>    2016-04-12 17:30:31 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>     2016-04-13 19:10:33 from Jim Nasby <Jim(dot)Nasby(at)BlueTreble(dot)com>    2016-04-12 17:31:09 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>  2016-04-12 17:38:56 from Andres Freund <andres(at)anarazel(dot)de>   2016-04-12 18:44:00 from Kevin Grittner <kgrittn(at)gmail(dot)com>    2016-04-12 18:56:25 from Andres Freund <andres(at)anarazel(dot)de>     2016-04-12 19:17:12 from Kevin Grittner <kgrittn(at)gmail(dot)com>      2016-04-12 19:28:01 from Andres Freund <andres(at)anarazel(dot)de>       2016-04-12 19:53:57 from Kevin Grittner <kgrittn(at)gmail(dot)com>        2016-04-12 20:14:07 from Kevin Grittner <kgrittn(at)gmail(dot)com>        2016-04-13 17:19:55 from Andres Freund <andres(at)anarazel(dot)de>         2016-04-13 17:25:14 from Robert Haas <robertmhaas(at)gmail(dot)com>          2016-04-13 17:35:44 from Andres Freund <andres(at)anarazel(dot)de>          2016-04-13 18:52:15 from Kevin Grittner <kgrittn(at)gmail(dot)com>           2016-04-13 18:56:37 from Andres Freund <andres(at)anarazel(dot)de>            2016-04-13 19:08:49 from Kevin Grittner <kgrittn(at)gmail(dot)com>             2016-04-13 19:21:05 from Robert Haas <robertmhaas(at)gmail(dot)com>             2016-04-13 19:22:02 from Andres Freund <andres(at)anarazel(dot)de>           2016-04-13 19:21:10 from Andres Freund <andres(at)anarazel(dot)de>            2016-04-13 20:01:48 from Andres Freund <andres(at)anarazel(dot)de>             2016-04-13 20:21:31 from Kevin Grittner <kgrittn(at)gmail(dot)com>              2016-04-13 20:47:01 from Andres Freund <andres(at)anarazel(dot)de>               2016-04-13 21:05:25 from Kevin Grittner <kgrittn(at)gmail(dot)com>                2016-04-13 21:23:56 from Andres Freund <andres(at)anarazel(dot)de>                 2016-04-14 14:58:17 from Alexander Korotkov <a(dot)korotkov(at)postgrespro(dot)ru> 📎              2016-04-16 20:44:52 from Noah Misch <noah(at)leadboat(dot)com>               2016-04-16 20:56:30 from Andres Freund <andres(at)anarazel(dot)de>                2016-04-16 21:52:44 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                 2016-04-16 22:04:39 from Andres Freund <andres(at)anarazel(dot)de>                  2016-04-16 22:27:06 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                   2016-04-16 22:39:31 from Andres Freund <andres(at)anarazel(dot)de>                2016-04-19 14:57:31 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                 2016-04-19 15:11:57 from Kevin Grittner <kgrittn(at)gmail(dot)com>                  2016-04-19 15:14:47 from Robert Haas <robertmhaas(at)gmail(dot)com>                   2016-04-19 15:20:40 from Kevin Grittner <kgrittn(at)gmail(dot)com>                   2016-04-20 05:45:25 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                  2016-04-23 11:55:46 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> 📎                 2016-04-20 14:09:00 from Andres Freund <andres(at)anarazel(dot)de>                  2016-04-22 13:12:56 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                 2016-04-21 01:08:01 from Ants Aasma <ants(dot)aasma(at)eesti(dot)ee> 📎                  2016-04-21 14:16:18 from Kevin Grittner <kgrittn(at)gmail(dot)com>                  2016-04-21 19:10:58 from Ants Aasma <ants(dot)aasma(at)eesti(dot)ee> 📎                   2016-04-21 21:13:24 from Kevin Grittner <kgrittn(at)gmail(dot)com>                    2016-04-22 13:06:05 from Kevin Grittner <kgrittn(at)gmail(dot)com>                     2016-04-29 22:08:49 from Kevin Grittner <kgrittn(at)gmail(dot)com>                      2016-05-02 13:03:19 from Robert Haas <robertmhaas(at)gmail(dot)com>                       2016-05-02 14:21:21 from Andres Freund <andres(at)anarazel(dot)de>                        2016-05-02 14:32:28 from Robert Haas <robertmhaas(at)gmail(dot)com>                         2016-05-03 15:39:54 from Andres Freund <andres(at)anarazel(dot)de>                        2016-05-03 05:24:38 from Bruce Momjian <bruce(at)momjian(dot)us>                       2016-05-02 15:15:40 from Ants Aasma <ants(dot)aasma(at)eesti(dot)ee>                        2016-05-02 15:57:05 from Andres Freund <andres(at)anarazel(dot)de>                  2016-04-22 13:21:55 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                  2016-05-06 19:18:22 from Kevin Grittner <kgrittn(at)gmail(dot)com> 📎                   2016-05-06 22:07:28 from Andres Freund <andres(at)anarazel(dot)de>                    2016-05-07 00:43:24 from Kevin Grittner <kgrittn(at)gmail(dot)com>                     2016-05-07 00:48:44 from Andres Freund <andres(at)anarazel(dot)de>                      2016-05-07 01:28:27 from Kevin Grittner <kgrittn(at)gmail(dot)com>                       2016-05-07 22:11:05 from Andres Freund <andres(at)anarazel(dot)de>                       2016-05-24 16:24:44 from Kevin Grittner <kgrittn(at)gmail(dot)com>                        2016-05-24 17:00:58 from Andres Freund <andres(at)anarazel(dot)de>                         2016-05-24 18:04:09 from Kevin Grittner <kgrittn(at)gmail(dot)com>                          2016-05-24 18:11:44 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>                          2016-05-24 18:12:06 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                          2016-05-24 18:13:24 from Andres Freund <andres(at)anarazel(dot)de>                         2016-05-24 19:48:35 from Kevin Grittner <kgrittn(at)gmail(dot)com>                          2016-05-24 20:01:40 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>                          2016-05-24 20:54:51 from Andres Freund <andres(at)anarazel(dot)de>                           2016-05-24 21:09:27 from Kevin Grittner <kgrittn(at)gmail(dot)com>                            2016-05-24 21:51:50 from Kevin Grittner <kgrittn(at)gmail(dot)com>                            2016-05-24 21:56:16 from Andres Freund <andres(at)anarazel(dot)de>                             2016-05-27 14:58:27 from Kevin Grittner <kgrittn(at)gmail(dot)com>                              2016-05-27 15:18:28 from Kevin Grittner <kgrittn(at)gmail(dot)com>                               2016-06-03 21:24:40 from Kevin Grittner <kgrittn(at)gmail(dot)com>                                2016-06-04 20:21:49 from Kevin Grittner <kgrittn(at)gmail(dot)com> 📎                                 2016-06-07 15:40:28 from Robert Haas <robertmhaas(at)gmail(dot)com>                                  2016-06-08 13:40:52 from Kevin Grittner <kgrittn(at)gmail(dot)com> 📎                                   2016-06-08 19:49:29 from Robert Haas <robertmhaas(at)gmail(dot)com>                                    2016-06-08 20:04:18 from Kevin Grittner <kgrittn(at)gmail(dot)com>                                     2016-06-08 20:11:40 from Robert Haas <robertmhaas(at)gmail(dot)com>                                      2016-06-09 14:28:06 from Kevin Grittner <kgrittn(at)gmail(dot)com> 📎                                       2016-06-09 23:16:13 from Robert Haas <robertmhaas(at)gmail(dot)com>                                        2016-06-10 14:45:01 from Kevin Grittner <kgrittn(at)gmail(dot)com>                                         2016-06-10 15:26:23 from Robert Haas <robertmhaas(at)gmail(dot)com>                                          2016-06-10 16:27:52 from Kevin Grittner <kgrittn(at)gmail(dot)com>                              2016-05-31 15:03:12 from Robert Haas <robertmhaas(at)gmail(dot)com>                               2016-05-31 16:20:43 from Kevin Grittner <kgrittn(at)gmail(dot)com>                          2016-05-24 21:10:51 from Robert Haas <robertmhaas(at)gmail(dot)com>                           2016-05-24 21:19:19 from Kevin Grittner <kgrittn(at)gmail(dot)com>                           2016-05-27 15:35:37 from Kevin Grittner <kgrittn(at)gmail(dot)com>                            2016-06-03 21:29:40 from Kevin Grittner <kgrittn(at)gmail(dot)com>                             2016-06-09 02:59:06 from Noah Misch <noah(at)leadboat(dot)com>                           2016-06-11 15:29:54 from Kevin Grittner <kgrittn(at)gmail(dot)com>                            2016-06-15 15:46:54 from Robert Haas <robertmhaas(at)gmail(dot)com>                             2016-06-15 17:44:34 from Kevin Grittner <kgrittn(at)gmail(dot)com>                              2016-06-15 18:29:22 from Robert Haas <robertmhaas(at)gmail(dot)com>                               2016-06-15 18:42:19 from Kevin Grittner <kgrittn(at)gmail(dot)com>                               2016-06-15 18:45:37 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>                                2016-06-15 18:50:18 from Kevin Grittner <kgrittn(at)gmail(dot)com>                                2016-06-15 18:50:46 from Robert Haas <robertmhaas(at)gmail(dot)com>                                 2016-06-15 18:54:31 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>                                  2016-06-15 19:00:30 from Kevin Grittner <kgrittn(at)gmail(dot)com>                                 2016-06-15 18:56:39 from Kevin Grittner <kgrittn(at)gmail(dot)com>                                  2016-06-15 18:59:50 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>                                   2016-06-15 19:05:31 from Kevin Grittner <kgrittn(at)gmail(dot)com>                                    2016-06-15 19:40:59 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>                                     2016-06-15 20:17:49 from "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>                                     2016-06-15 22:23:57 from Kevin Grittner <kgrittn(at)gmail(dot)com>                                      2016-06-16 02:43:05 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>                                   2016-06-15 19:48:54 from Robert Haas <robertmhaas(at)gmail(dot)com>                                 2016-06-15 19:20:11 from Andres Freund <andres(at)anarazel(dot)de>                                  2016-06-15 19:24:58 from Kevin Grittner <kgrittn(at)gmail(dot)com>                                   2016-06-15 20:25:52 from Andres Freund <andres(at)anarazel(dot)de>                                    2016-06-15 21:58:25 from Kevin Grittner <kgrittn(at)gmail(dot)com>                                     2016-06-15 22:34:40 from Andres Freund <andres(at)anarazel(dot)de>                                      2016-06-16 01:22:24 from Kevin Grittner <kgrittn(at)gmail(dot)com>                                       2016-06-16 01:57:30 from Andres Freund <andres(at)anarazel(dot)de>                                        2016-06-16 14:50:09 from Kevin Grittner <kgrittn(at)gmail(dot)com>                                         2016-06-16 15:37:45 from Andres Freund <andres(at)anarazel(dot)de>                                          2016-06-16 16:02:39 from Robert Haas <robertmhaas(at)gmail(dot)com>                                           2016-06-16 16:14:26 from Andres Freund <andres(at)anarazel(dot)de>                                            2016-06-16 16:43:34 from Robert Haas <robertmhaas(at)gmail(dot)com>                                             2016-06-16 16:54:40 from Andres Freund <andres(at)anarazel(dot)de>                                              2016-06-16 17:44:34 from Robert Haas <robertmhaas(at)gmail(dot)com>                                               2016-06-16 18:01:41 from Andres Freund <andres(at)anarazel(dot)de>                                                2016-06-16 18:16:35 from Kevin Grittner <kgrittn(at)gmail(dot)com>                                                 2016-06-16 18:32:07 from Andres Freund <andres(at)anarazel(dot)de>                                                  2016-06-16 18:56:44 from Kevin Grittner <kgrittn(at)gmail(dot)com>                                                   2016-07-01 03:51:18 from Noah Misch <noah(at)leadboat(dot)com>                                                    2016-07-01 06:48:26 from Andres Freund <andres(at)anarazel(dot)de>                                                     2016-07-01 12:17:08 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                      2016-07-01 14:00:45 from Kevin Grittner <kgrittn(at)gmail(dot)com>                                                       2016-07-02 18:29:34 from Noah Misch <noah(at)leadboat(dot)com>                                                        2016-07-02 19:20:13 from Kevin Grittner <kgrittn(at)gmail(dot)com> 📎                                                         2016-07-02 22:10:02 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                          2016-07-03 13:32:46 from Kevin Grittner <kgrittn(at)gmail(dot)com>                                                         2016-07-06 21:55:56 from Andres Freund <andres(at)anarazel(dot)de>                                                          2016-07-08 16:00:50 from Kevin Grittner <kgrittn(at)gmail(dot)com>                                                           2016-07-08 17:53:49 from Andres Freund <andres(at)anarazel(dot)de>                                                            2016-07-08 18:32:35 from Kevin Grittner <kgrittn(at)gmail(dot)com>                                                             2016-07-08 18:52:21 from Andres Freund <andres(at)anarazel(dot)de>                                                              2016-07-12 15:04:45 from Kevin Grittner <kgrittn(at)gmail(dot)com>                                                               2016-07-13 12:57:46 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                                                2016-07-13 15:06:52 from Kevin Grittner <kgrittn(at)gmail(dot)com>                                                                 2016-07-13 17:48:38 from Andres Freund <andres(at)anarazel(dot)de>                                                                  2016-07-13 20:57:02 from Kevin Grittner <kgrittn(at)gmail(dot)com>                                                                   2016-07-13 21:05:25 from Andres Freund <andres(at)anarazel(dot)de>                                                                   2016-07-16 22:48:08 from Noah Misch <noah(at)leadboat(dot)com>                                                                    2016-07-19 02:10:47 from Noah Misch <noah(at)leadboat(dot)com>                                                                     2016-07-19 23:09:59 from Kevin Grittner <kgrittn(at)gmail(dot)com>                                                                      2016-07-19 23:32:50 from Andres Freund <andres(at)anarazel(dot)de>                                                                       2016-07-20 02:14:42 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                                                        2016-07-20 02:27:40 from Andres Freund <andres(at)anarazel(dot)de>                                                                         2016-07-20 02:43:05 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                                                          2016-07-20 07:39:50 from Andres Freund <andres(at)anarazel(dot)de>                                                                           2016-07-20 15:26:11 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                                            2016-07-20 16:30:33 from Andres Freund <andres(at)anarazel(dot)de>                                                                             2016-07-20 17:56:19 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>                                                                             2016-07-20 17:59:32 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                                              2016-07-20 18:12:13 from Andres Freund <andres(at)anarazel(dot)de>                                                                       2016-07-20 13:37:59 from Kevin Grittner <kgrittn(at)gmail(dot)com>                                                                      2016-07-20 01:01:05 from Noah Misch <noah(at)leadboat(dot)com>                                                                       2016-07-21 01:15:46 from Noah Misch <noah(at)leadboat(dot)com>                                                                        2016-07-21 16:06:45 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                               2016-07-13 17:47:17 from Andres Freund <andres(at)anarazel(dot)de>                                              2016-06-16 18:19:13 from Kevin Grittner <kgrittn(at)gmail(dot)com>                                               2016-06-16 18:40:39 from Andres Freund <andres(at)anarazel(dot)de>                                               2016-06-16 18:53:01 from Kevin Grittner <kgrittn(at)gmail(dot)com>                                                2016-06-16 18:57:48 from Andres Freund <andres(at)anarazel(dot)de>                                                 2016-06-16 19:01:34 from Andres Freund <andres(at)anarazel(dot)de>               2016-04-17 15:46:42 from David Steele <david(at)pgmasters(dot)net>                2016-04-17 17:04:37 from Andres Freund <andres(at)anarazel(dot)de>     2016-04-13 02:52:14 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>      2016-04-13 03:05:30 from Andres Freund <andres(at)anarazel(dot)de>       2016-04-13 12:36:47 from Robert Haas <robertmhaas(at)gmail(dot)com>        2016-04-13 13:52:04 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>         2016-04-13 14:11:06 from Robert Haas <robertmhaas(at)gmail(dot)com>          2016-04-13 14:20:37 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>           2016-04-13 14:32:58 from Robert Haas <robertmhaas(at)gmail(dot)com>            2016-04-13 14:42:03 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>             2016-04-13 15:01:37 from Robert Haas <robertmhaas(at)gmail(dot)com>              2016-04-13 15:30:32 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>             2016-04-13 15:18:01 from Andres Freund <andres(at)anarazel(dot)de>              2016-04-13 15:27:09 from Robert Haas <robertmhaas(at)gmail(dot)com>               2016-04-13 15:38:07 from Andres Freund <andres(at)anarazel(dot)de>        2016-04-13 14:08:21 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>         2016-04-13 15:08:39 from Andres Freund <andres(at)anarazel(dot)de>        2016-04-13 15:01:16 from Andres Freund <andres(at)anarazel(dot)de>         2016-04-13 15:06:09 from Robert Haas <robertmhaas(at)gmail(dot)com>         2016-04-13 15:31:19 from Kevin Grittner <kgrittn(at)gmail(dot)com>          2016-04-13 15:59:42 from Andres Freund <andres(at)anarazel(dot)de>           2016-04-13 16:25:47 from Kevin Grittner <kgrittn(at)gmail(dot)com>   2016-04-29 17:01:21 from Bruce Momjian <bruce(at)momjian(dot)us>    2016-04-29 17:20:40 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>     2016-04-29 17:26:32 from "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>      2016-04-29 17:49:38 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>       2016-04-29 18:20:16 from Bruce Momjian <bruce(at)momjian(dot)us>        2016-04-29 18:27:15 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>         2016-04-29 18:44:04 from Andres Freund <andres(at)anarazel(dot)de>     2016-04-29 19:07:46 from Bruce Momjian <bruce(at)momjian(dot)us>
Lists:	pgsql-committers pgsql-hackers

In response to

• Re: [HACKERS] Re: pgsql: Avoid extra locks in GetSnapshotData if old_snapshot_threshold < at 2016-06-16 18:57:48 from Andres Freund

Browse pgsql-committers by date

	From	Date	Subject
Next Message	Tom Lane	2016-06-16 19:20:34	pgsql: Fix fuzzy thinking in ReinitializeParallelDSM().
Previous Message	Andres Freund	2016-06-16 18:57:48	Re: [HACKERS] Re: pgsql: Avoid extra locks in GetSnapshotData if old_snapshot_threshold <

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Pavel Stehule	2016-06-16 19:10:41	Re: proposal: integration bloat tables (indexes) to core
Previous Message	Andres Freund	2016-06-16 18:57:48	Re: [HACKERS] Re: pgsql: Avoid extra locks in GetSnapshotData if old_snapshot_threshold <