| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Robert Haas <robertmhaas(at)gmail(dot)com> |
| Cc: | Peter Eisentraut <peter(dot)eisentraut(at)enterprisedb(dot)com>, Bruce Momjian <bruce(at)momjian(dot)us>, pgsql-committers <pgsql-committers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: pgsql: doc: clarify recursion internal behavior |
| Date: | 2022-09-08 15:30:04 |
| Message-ID: | 3976627.1662651004@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-committers |
Robert Haas <robertmhaas(at)gmail(dot)com> writes:
> On Thu, Sep 8, 2022 at 7:24 AM Peter Eisentraut
> <peter(dot)eisentraut(at)enterprisedb(dot)com> wrote:
>> On 03.09.22 03:58, Bruce Momjian wrote:
>>> + While <literal>RECURSIVE</literal> allows queries to be specified
>>> + recursively, internally all queries are evaluated iteratively.
>> Is that true? Surely there is some recursive behavior in the executor.
> I haven't read the patch, but I think the claim shown here is correct.
I'd be happier if it read "such queries" instead of "all queries".
The latter is an extremely broad claim, and you have to ignore cases
like recursive SQL functions in order to even argue it's true.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Geoghegan | 2022-09-08 17:31:01 | pgsql: Instrument freezing in autovacuum log reports. |
| Previous Message | Robert Haas | 2022-09-08 15:15:34 | Re: pgsql: doc: clarify recursion internal behavior |