Re: psql's FETCH_COUNT (cursor) is not being respected for CTEs

From:	"Daniel Verite" <daniel(at)manitou-mail(dot)org>
To:	"vignesh C" <vignesh21(at)gmail(dot)com>
Cc:	PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Robert Haas <robertmhaas(at)gmail(dot)com>, Jakub Wartak <jakub(dot)wartak(at)enterprisedb(dot)com>
Subject:	Re: psql's FETCH_COUNT (cursor) is not being respected for CTEs
Date:	2024-01-30 14:29:37
Message-ID:	b3609dbf-5880-4ead-bb83-c1ccea7c879d@manitou-mail.org
Views:	Raw Message | Whole Thread | Download mbox | Resend email
Thread:	2023-01-04 12:10:20 from Jakub Wartak <jakub(dot)wartak(at)enterprisedb(dot)com> 📎  2023-01-04 15:22:03 from "Daniel Verite" <daniel(at)manitou-mail(dot)org>   2023-01-04 15:57:28 from Robert Haas <robertmhaas(at)gmail(dot)com>    2023-01-04 16:36:51 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>     2023-01-04 17:38:17 from Robert Haas <robertmhaas(at)gmail(dot)com>      2023-01-10 12:23:19 from Jakub Wartak <jakub(dot)wartak(at)enterprisedb(dot)com> 📎     2023-01-12 12:27:32 from "Daniel Verite" <daniel(at)manitou-mail(dot)org> 📎      2023-03-01 10:41:13 from "Daniel Verite" <daniel(at)manitou-mail(dot)org> 📎       2023-03-24 20:12:58 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>        2023-07-07 17:42:57 from "Daniel Verite" <daniel(at)manitou-mail(dot)org> 📎         2023-11-20 19:13:35 from "Daniel Verite" <daniel(at)manitou-mail(dot)org> 📎          2024-01-02 14:58:14 from "Daniel Verite" <daniel(at)manitou-mail(dot)org> 📎           2024-01-27 03:31:23 from vignesh C <vignesh21(at)gmail(dot)com>            2024-01-30 14:29:37 from "Daniel Verite" <daniel(at)manitou-mail(dot)org> 📎             2024-02-08 11:06:33 from Jakub Wartak <jakub(dot)wartak(at)enterprisedb(dot)com>              2024-02-12 18:30:30 from "Daniel Verite" <daniel(at)manitou-mail(dot)org>             2024-03-29 13:07:06 from Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>              2024-03-29 17:25:29 from Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>               2024-04-01 17:52:42 from "Daniel Verite" <daniel(at)manitou-mail(dot)org> 📎                2024-04-02 16:50:14 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                 2024-04-02 20:09:04 from "Daniel Verite" <daniel(at)manitou-mail(dot)org>                  2024-04-02 20:13:23 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                   2024-04-02 20:54:47 from "Daniel Verite" <daniel(at)manitou-mail(dot)org>                    2024-04-07 00:53:56 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                     2024-04-08 14:25:36 from "Daniel Verite" <daniel(at)manitou-mail(dot)org>                      2024-04-08 15:00:00 from Alexander Lakhin <exclusion(at)gmail(dot)com>                       2024-04-08 15:08:24 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                        2024-04-08 15:15:15 from Alexander Lakhin <exclusion(at)gmail(dot)com>                         2024-04-08 20:03:21 from "Daniel Verite" <daniel(at)manitou-mail(dot)org>                         2024-04-08 20:04:50 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>              2024-04-01 16:09:55 from "Daniel Verite" <daniel(at)manitou-mail(dot)org>
Lists:	pgsql-hackers

Attachment	Content-Type	Size
v6-0001-Implement-retrieval-of-results-in-chunks-with-lib.patch	text/plain	18.6 KB
v6-0002-Reimplement-FETCH_COUNT-with-the-chunked-mode-in-.patch	text/plain	20.6 KB

In response to

• Re: psql's FETCH_COUNT (cursor) is not being respected for CTEs at 2024-01-27 03:31:23 from vignesh C

Responses

• Re: psql's FETCH_COUNT (cursor) is not being respected for CTEs at 2024-02-08 11:06:33 from Jakub Wartak
• Re: psql's FETCH_COUNT (cursor) is not being respected for CTEs at 2024-03-29 13:07:06 from Laurenz Albe

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Tom Lane	2024-01-30 14:36:06	Re: scram_iterations is undocumented GUC_REPORT
Previous Message	jian he	2024-01-30 14:15:20	Re: POC, WIP: OR-clause support for indexes