| From: | "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com> |
|---|---|
| To: | Andreas Karlsson <andreas(at)proxel(dot)se> |
| Cc: | PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Proposing WITH ITERATIVE |
| Date: | 2020-04-28 15:15:20 |
| Message-ID: | CADUqk8XS4YTWXq71m9Zgp5dAWy_12w9ZogEda=8DhTdPARSfwQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Tue, Apr 28, 2020 at 6:19 AM Andreas Karlsson <andreas(at)proxel(dot)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:
http://faculty.neu.edu.cn/cc/zhangyf/papers/2018-ICDCS2018-sqloop.pdf
http://db.in.tum.de/~passing/publications/dm_in_hyper.pdf
--
Jonah H. Harris
| From | Date | Subject | |
|---|---|---|---|
| Next Message | davinder singh | 2020-04-28 15:15:47 | Re: PG compilation error with Visual Studio 2015/2017/2019 |
| Previous Message | Holger Jakobs | 2020-04-28 15:10:31 | Re: PostgreSQL CHARACTER VARYING vs CHARACTER VARYING (Length) |