Re: [HACKERS] pgbench - allow to store select results into variables

From:	Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr>
To:	Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
Cc:	Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp>, rafia(dot)sabih(at)enterprisedb(dot)com, Michael Paquier <michael(dot)paquier(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>, Robert Haas <robertmhaas(at)gmail(dot)com>, PostgreSQL Developers <pgsql-hackers(at)postgresql(dot)org>
Subject:	Re: [HACKERS] pgbench - allow to store select results into variables
Date:	2018-01-10 08:54:13
Message-ID:	alpine.DEB.2.20.1801100952040.2283@lancre
Views:	Raw Message | Whole Thread | Download mbox | Resend email
Thread:	2016-07-09 08:20:39 from Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr> 📎  2016-07-09 08:44:56 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>   2016-07-09 09:19:15 from Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr>    2016-07-09 12:19:29 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>     2016-07-09 12:52:51 from Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr>      2016-07-13 19:34:24 from Robert Haas <robertmhaas(at)gmail(dot)com>       2016-07-13 20:02:23 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>        2016-07-13 20:07:16 from Robert Haas <robertmhaas(at)gmail(dot)com>         2016-07-13 20:13:43 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>        2016-07-13 21:31:16 from "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>        2016-07-14 08:02:18 from Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr>        2016-07-15 05:13:33 from Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr>        2016-07-15 16:33:33 from Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr> 📎         2016-09-02 02:58:03 from Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>          2016-09-02 17:47:22 from Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr> 📎           2016-09-05 08:09:32 from Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>            2016-09-07 14:01:25 from Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr> 📎             2016-09-12 07:33:39 from Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>              2016-09-13 08:41:28 from Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr> 📎               2016-09-14 10:39:17 from Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>                2016-09-18 11:13:44 from Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr>                 2016-09-26 07:12:08 from Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>                  2016-09-26 08:19:53 from Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>                   2016-09-26 11:27:10 from Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr> 📎                    2016-09-27 01:41:53 from Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>                     2016-10-02 13:43:01 from Michael Paquier <michael(dot)paquier(at)gmail(dot)com>                      2016-12-02 06:33:15 from Haribabu Kommi <kommi(dot)haribabu(at)gmail(dot)com>                    2017-01-04 21:15:58 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                     2017-01-05 09:47:43 from Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr>                     2017-01-07 09:25:06 from Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr> 📎                      2017-01-29 08:15:34 from Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr>                      2017-01-31 06:13:03 from Michael Paquier <michael(dot)paquier(at)gmail(dot)com>                       2017-01-31 06:24:29 from Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr>                        2017-03-15 05:53:18 from Rafia Sabih <rafia(dot)sabih(at)enterprisedb(dot)com>                         2017-03-15 19:15:07 from Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr>                          2017-03-23 10:59:37 from Rafia Sabih <rafia(dot)sabih(at)enterprisedb(dot)com>                           2017-03-24 15:29:22 from Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr> 📎                            2017-03-27 10:49:37 from Rafia Sabih <rafia(dot)sabih(at)enterprisedb(dot)com>                             2017-04-05 00:45:48 from Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp>                              2017-04-05 18:28:46 from Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr> 📎                               2017-04-06 00:07:10 from Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp>                                2017-04-06 00:24:19 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                 2017-04-06 00:28:24 from Andres Freund <andres(at)anarazel(dot)de>                                 2017-04-06 00:36:50 from Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp>                                  2017-04-07 00:17:05 from Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp>                                   2017-04-07 07:55:28 from Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr>                                    2017-04-07 08:06:20 from Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp>                                     2017-04-07 09:43:53 from Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr>                                      2017-04-08 20:24:37 from Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr> 📎                                       2017-04-08 20:32:17 from Fabien COELHO <fabien(dot)coelho(at)mines-paristech(dot)fr> 📎                                        2017-04-09 23:32:19 from Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp>                                         2017-04-17 06:34:53 from Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr> 📎                                          2017-04-17 09:11:23 from Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp>                                           2017-04-17 11:00:07 from Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr> 📎                                            2017-04-20 08:06:40 from Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp>                                             2017-04-22 04:58:34 from Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr>                                             2017-09-04 17:46:52 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                              2017-09-04 19:12:40 from Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr>                                       2017-04-08 20:37:07 from Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr> 📎                               2017-04-17 06:40:31 from Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr> 📎                                2017-08-13 18:33:32 from Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr> 📎                                 2017-08-13 19:45:29 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>                                  2017-09-08 17:17:56 from Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr> 📎                                   2017-10-20 16:37:38 from Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr> 📎                                    2017-10-25 09:55:18 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>                                     2017-11-04 11:05:39 from Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr> 📎                                      2017-12-01 02:57:35 from Michael Paquier <michael(dot)paquier(at)gmail(dot)com>                                       2017-12-01 05:48:10 from Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr>                                      2018-01-10 08:54:13 from Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr> 📎                                       2018-03-24 09:25:54 from Fabien COELHO <fabien(dot)coelho(at)mines-paristech(dot)fr> 📎                                        2018-04-06 20:55:26 from Stephen Frost <sfrost(at)snowman(dot)net>                                        2018-04-07 03:17:25 from Stephen Frost <sfrost(at)snowman(dot)net>                                         2018-04-07 16:06:23 from Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr> 📎                                          2018-04-08 00:00:01 from Stephen Frost <sfrost(at)snowman(dot)net>                                           2018-04-08 05:58:31 from Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr>                                            2018-04-27 16:28:31 from Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr> 📎                                             2018-08-13 22:04:55 from Andrew Dunstan <andrew(dot)dunstan(at)2ndquadrant(dot)com>                                              2018-08-13 22:30:55 from Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr> 📎                                               2018-08-14 10:47:43 from Andrew Dunstan <andrew(dot)dunstan(at)2ndquadrant(dot)com>                                                2018-08-14 11:37:16 from Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk>                                                 2018-08-14 11:56:29 from Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr>                                                  2018-08-14 17:44:11 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                   2018-08-14 18:23:25 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                   2018-08-14 19:10:14 from Andrew Dunstan <andrew(dot)dunstan(at)2ndquadrant(dot)com>                                                   2018-08-14 20:44:16 from Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr>                                                    2018-08-14 20:53:11 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>                                                 2018-08-14 12:35:49 from Andrew Dunstan <andrew(dot)dunstan(at)2ndquadrant(dot)com>                                                  2018-08-14 12:43:32 from Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk>                                                2018-08-14 11:38:21 from Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr> 📎                                                 2018-09-12 06:35:42 from Michael Paquier <michael(at)paquier(dot)xyz>                                                  2018-10-02 06:43:04 from Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr> 📎                                                   2018-10-15 13:09:38 from Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr> 📎                                                    2018-11-16 22:36:11 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>                                                     2018-11-17 10:43:27 from Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr>                                                      2018-11-17 11:06:54 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>                                                       2018-11-18 10:23:08 from Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr> 📎                                                        2018-11-21 19:42:52 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> 📎                                                         2018-11-24 07:45:38 from Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr> 📎                                                          2018-11-24 15:36:09 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>                                                           2018-11-24 16:57:54 from Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr>                                                            2019-01-03 17:51:02 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> 📎                                                             2019-01-06 18:29:45 from Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr> 📎                                                              2019-01-09 07:16:48 from Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr> 📎                                                               2019-01-09 13:41:43 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>                                                                2019-01-09 15:31:24 from Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr> 📎                                                                 2019-01-09 23:00:39 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> 📎                                                                  2019-01-10 09:12:26 from Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr> 📎                                                                   2019-01-10 16:43:25 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>                                                                    2019-01-10 18:20:59 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                                     2019-01-10 19:00:33 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>                                                                      2019-01-10 19:14:25 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                                       2019-01-10 19:49:35 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>                                                                        2019-01-10 21:23:34 from Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr>                                                                       2019-01-10 21:01:12 from Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr>                                      2018-11-16 21:43:07 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>                                       2018-11-16 22:13:13 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>                                       2018-11-17 10:25:32 from Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr> 📎       2016-07-13 20:16:25 from Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr>        2016-07-13 20:26:12 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>         2016-07-13 21:19:07 from Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr>
Lists:	pgsql-hackers

Attachment	Content-Type	Size
pgbench-into-15.patch	text/x-diff	21.2 KB

In response to

• Re: pgbench - allow to store select results into variables at 2017-11-04 11:05:39 from Fabien COELHO

Responses

• Re: [HACKERS] pgbench - allow to store select results into variables at 2018-03-24 09:25:54 from Fabien COELHO

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Konstantin Knizhnik	2018-01-10 09:24:02	Re: AS OF queries
Previous Message	Teodor Sigaev	2018-01-10 08:36:26	Re: pgsql: Improve scripting language in pgbench