Re: RFC: Async query processing - Mailing list pgsql-hackers

From Florian Weimer
Subject Re: RFC: Async query processing
Date
Msg-id 52C980D2.9090602@redhat.com
Whole thread Raw
In response to Re: RFC: Async query processing  (Greg Stark <stark@mit.edu>)
List pgsql-hackers
On 01/05/2014 03:11 PM, Greg Stark wrote:
> On Fri, Jan 3, 2014 at 3:20 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> I think Florian has a good point there, and the reason is this: what
>> you are talking about will be of exactly zero use to applications that
>> want to see the results of one query before launching the next.
>
> There are techniques for handling that actually. For a better
> explanation than I can do see
> http://kentonv.github.io/capnproto/rpc.html. It's mostly a language
> feature but it does require support from the protocol to be able to
> reference data in earlier responses in your subsequent requests.

Purely from a perspective of latency avoidance, sub-queries, WITH or 
stored procedures can achieve the same thing, and work even if the 
intermediate result has to undergo some transformation. :-)

-- 
Florian Weimer / Red Hat Product Security Team



pgsql-hackers by date:

Previous
From: Greg Stark
Date:
Subject: Re: RFC: Async query processing
Next
From: Florian Weimer
Date:
Subject: Re: RFC: Async query processing