Re: Proposing WITH ITERATIVE - Mailing list pgsql-hackers

From Jonah H. Harris
Subject Re: Proposing WITH ITERATIVE
Date
Msg-id CADUqk8XS4YTWXq71m9Zgp5dAWy_12w9ZogEda=8DhTdPARSfwQ@mail.gmail.com
Whole thread Raw
In response to Re: Proposing WITH ITERATIVE  (Andreas Karlsson <andreas@proxel.se>)
Responses Re: Proposing WITH ITERATIVE  (Stephen Frost <sfrost@snowman.net>)
List pgsql-hackers
On Tue, Apr 28, 2020 at 6:19 AM Andreas Karlsson <andreas@proxel.se> wrote:
Do you have any examples of queries where it would help? It is pretty
hard to say how much value some new syntax adds without seeing how it
improves an intended use case.

Hey, Andreas.

Thanks for the response. I'm currently working on a few examples per Jeff's response along with some benchmark information including improvements in response time and memory usage of the current implementation. In the meantime, as this functionality has been added to a couple of other databases and there's academic research on it, if you're interested, here's a few papers with examples:


--
Jonah H. Harris

pgsql-hackers by date:

Previous
From: "Jonah H. Harris"
Date:
Subject: Re: Proposing WITH ITERATIVE
Next
From: davinder singh
Date:
Subject: Re: PG compilation error with Visual Studio 2015/2017/2019