Re: FETCH FIRST clause PERCENT option

From:	Surafel Temesgen <surafel3000(at)gmail(dot)com>
To:	Vik Fearing <vik(dot)fearing(at)2ndquadrant(dot)com>
Cc:	Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>, Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>, Ryan Lambert <ryan(at)rustprooflabs(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject:	Re: FETCH FIRST clause PERCENT option
Date:	2020-08-10 10:23:44
Message-ID:	CALAY4q-zYNnj4eN7danY3h8YpZuCRq7JHnB5Ov7M7PAn8dcrPg@mail.gmail.com
Views:	Raw Message | Whole Thread | Download mbox | Resend email
Thread:	2018-08-16 14:27:45 from Surafel Temesgen <surafel3000(at)gmail(dot)com> 📎  2018-08-16 14:34:21 from Andres Freund <andres(at)anarazel(dot)de>   2018-08-16 14:52:06 from Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk>   2018-08-21 12:47:07 from Surafel Temesgen <surafel3000(at)gmail(dot)com>    2018-08-21 12:50:25 from Andres Freund <andres(at)anarazel(dot)de>     2018-08-28 12:14:43 from Surafel Temesgen <surafel3000(at)gmail(dot)com> 📎      2018-08-28 16:33:38 from Erik Rijkers <er(at)xs4all(dot)nl>       2018-08-31 11:42:05 from Surafel Temesgen <surafel3000(at)gmail(dot)com> 📎        2018-09-20 22:05:12 from Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com>   2018-09-21 00:06:36 from Mark Dilger <hornschnorter(at)gmail(dot)com>    2018-09-21 00:29:20 from Andres Freund <andres(at)anarazel(dot)de>     2018-09-21 15:28:53 from Mark Dilger <hornschnorter(at)gmail(dot)com>    2018-09-25 12:07:17 from Surafel Temesgen <surafel3000(at)gmail(dot)com> 📎     2018-09-25 15:08:00 from Mark Dilger <hornschnorter(at)gmail(dot)com>      2018-09-25 15:54:48 from Mark Dilger <hornschnorter(at)gmail(dot)com>      2018-11-25 09:00:43 from Surafel Temesgen <surafel3000(at)gmail(dot)com> 📎       2018-11-25 10:24:03 from Vik Fearing <vik(dot)fearing(at)2ndquadrant(dot)com>        2018-11-25 11:49:53 from Surafel Temesgen <surafel3000(at)gmail(dot)com>         2018-11-25 12:05:23 from Vik Fearing <vik(dot)fearing(at)2ndquadrant(dot)com>          2018-11-25 18:23:55 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>           2018-11-25 18:31:08 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>          2018-11-30 07:23:42 from Surafel Temesgen <surafel3000(at)gmail(dot)com> 📎           2018-11-30 10:22:07 from Surafel Temesgen <surafel3000(at)gmail(dot)com> 📎            2019-01-01 19:08:30 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>             2019-01-03 12:00:29 from Surafel Temesgen <surafel3000(at)gmail(dot)com>              2019-01-03 13:51:43 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>               2019-01-04 06:40:32 from Surafel Temesgen <surafel3000(at)gmail(dot)com>                2019-01-04 14:27:38 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>                 2019-01-06 11:40:29 from Surafel Temesgen <surafel3000(at)gmail(dot)com>                  2019-01-06 14:51:48 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>                   2019-01-09 06:09:33 from Surafel Temesgen <surafel3000(at)gmail(dot)com>                    2019-01-09 14:38:03 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>                     2019-01-09 15:43:54 from Surafel Temesgen <surafel3000(at)gmail(dot)com> 📎                      2019-01-09 17:18:06 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com> 📎                       2019-01-24 09:57:08 from Surafel Temesgen <surafel3000(at)gmail(dot)com> 📎                        2019-01-27 22:28:39 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>                         2019-01-30 06:07:40 from Surafel Temesgen <surafel3000(at)gmail(dot)com>                          2019-02-01 11:10:38 from Surafel Temesgen <surafel3000(at)gmail(dot)com> 📎                           2019-02-09 23:32:59 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>                          2019-02-09 23:22:41 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>                           2019-02-23 07:53:36 from Surafel Temesgen <surafel3000(at)gmail(dot)com>                            2019-02-23 21:27:44 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>                             2019-02-28 10:32:17 from Surafel Temesgen <surafel3000(at)gmail(dot)com> 📎                              2019-02-28 11:49:36 from Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp>                               2019-03-29 09:04:50 from Surafel Temesgen <surafel3000(at)gmail(dot)com> 📎                                2019-03-31 21:34:31 from Andres Freund <andres(at)anarazel(dot)de>                                 2019-03-31 21:57:37 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                 2019-04-05 11:42:33 from Surafel Temesgen <surafel3000(at)gmail(dot)com>                                 2019-06-27 09:06:05 from Surafel Temesgen <surafel3000(at)gmail(dot)com> 📎                                  2019-07-08 01:37:13 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com>                                   2019-07-08 02:35:29 from Ryan Lambert <ryan(at)rustprooflabs(dot)com>                                   2019-07-08 07:08:36 from Surafel Temesgen <surafel3000(at)gmail(dot)com> 📎                                    2019-07-08 22:27:22 from Ryan Lambert <ryan(at)rustprooflabs(dot)com>                                     2019-07-09 11:41:07 from Surafel Temesgen <surafel3000(at)gmail(dot)com>                                      2019-07-09 13:13:10 from Ryan Lambert <ryan(at)rustprooflabs(dot)com>                                       2019-07-10 03:56:32 from Ryan Lambert <ryan(at)rustprooflabs(dot)com>                                        2019-07-10 06:02:57 from Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>                                         2019-07-10 07:42:59 from Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>                                       2019-07-17 09:45:17 from Surafel Temesgen <surafel3000(at)gmail(dot)com>                                        2019-07-17 20:06:47 from Ryan Lambert <ryan(at)rustprooflabs(dot)com>                                         2019-08-01 12:54:11 from Surafel Temesgen <surafel3000(at)gmail(dot)com> 📎                                          2019-08-06 22:52:12 from Ryan Lambert <ryan(at)rustprooflabs(dot)com> 📎                                          2019-08-07 03:10:45 from Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>                                           2019-08-07 07:20:09 from Surafel Temesgen <surafel3000(at)gmail(dot)com>                                            2019-08-18 23:33:51 from Ryan Lambert <ryan(at)rustprooflabs(dot)com>                                             2019-08-19 07:47:28 from Erik Rijkers <er(at)xs4all(dot)nl>                                              2019-08-19 09:18:39 from Surafel Temesgen <surafel3000(at)gmail(dot)com> 📎                                               2019-08-19 10:55:17 from Erik Rijkers <er(at)xs4all(dot)nl>                                                2019-08-19 11:11:48 from Surafel Temesgen <surafel3000(at)gmail(dot)com>                                            2019-08-20 06:10:24 from Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>                                             2019-08-22 07:40:30 from Surafel Temesgen <surafel3000(at)gmail(dot)com> 📎                                              2019-08-28 21:56:54 from Ryan Lambert <ryan(at)rustprooflabs(dot)com>                                              2019-09-05 22:26:29 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                               2019-09-06 11:16:22 from Surafel Temesgen <surafel3000(at)gmail(dot)com>                                                2019-09-19 12:52:32 from Surafel Temesgen <surafel3000(at)gmail(dot)com> 📎                                                 2019-09-26 21:13:42 from Ryan Lambert <ryan(at)rustprooflabs(dot)com>                                                  2019-09-27 00:59:19 from Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>                                                   2019-09-30 16:47:04 from Ryan Lambert <ryan(at)rustprooflabs(dot)com>                                                    2020-01-16 21:33:58 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>                                                     2020-01-17 06:20:08 from Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>                                                      2020-01-17 08:13:06 from Vik Fearing <vik(dot)fearing(at)2ndquadrant(dot)com>                                                       2020-08-10 10:23:44 from Surafel Temesgen <surafel3000(at)gmail(dot)com> 📎                                                        2020-09-24 03:57:57 from Michael Paquier <michael(at)paquier(dot)xyz>                                                         2020-09-25 09:25:24 from Surafel Temesgen <surafel3000(at)gmail(dot)com> 📎                                                          2021-01-25 11:39:18 from Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>                                                           2021-01-26 09:19:19 from Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)ec> 📎                                                           2021-01-26 16:29:11 from Surafel Temesgen <surafel3000(at)gmail(dot)com>                                                            2021-03-25 15:15:10 from David Steele <david(at)pgmasters(dot)net>                                                             2021-09-28 15:58:53 from Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)ec>                                                            2021-09-30 18:31:16 from Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)ec>                                    2019-07-10 15:44:27 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>                                     2019-07-11 06:53:15 from Surafel Temesgen <surafel3000(at)gmail(dot)com>                             2019-02-28 11:26:25 from Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp>                              2019-02-28 20:16:25 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>                               2019-03-01 01:31:45 from Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp>                                2019-03-01 12:47:43 from Surafel Temesgen <surafel3000(at)gmail(dot)com> 📎                                2019-03-01 16:18:04 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>                                 2019-03-25 08:53:26 from David Steele <david(at)pgmasters(dot)net>                               2019-03-26 12:06:52 from Surafel Temesgen <surafel3000(at)gmail(dot)com>                                2019-03-26 14:46:15 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>                                 2019-04-05 10:53:56 from Surafel Temesgen <surafel3000(at)gmail(dot)com>                                 2019-04-05 12:14:56 from Surafel Temesgen <surafel3000(at)gmail(dot)com>                                  2019-04-05 15:11:45 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>             2019-01-04 07:08:50 from Surafel Temesgen <surafel3000(at)gmail(dot)com>              2019-01-04 14:57:59 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>         2018-11-25 13:52:46 from Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk>
Lists:	pgsql-hackers

Attachment	Content-Type	Size
percent-incremental-v10.patch	text/x-patch	28.9 KB
percent_with_ties_v1.patch	text/x-patch	14.6 KB

In response to

• Re: FETCH FIRST clause PERCENT option at 2020-01-17 08:13:06 from Vik Fearing

Responses

• Re: FETCH FIRST clause PERCENT option at 2020-09-24 03:57:57 from Michael Paquier

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Bharath Rupireddy	2020-08-10 10:52:21	Re: Issue with cancel_before_shmem_exit while searching to remove a particular registered exit callbacks
Previous Message	Asim Praveen	2020-08-10 08:53:34	Re: Unnecessary delay in streaming replication due to replay lag