Re: [HACKERS] I want to change libpq and libpgtcl for better handling of large query results - Mailing list pgsql-hackers

From Vadim B. Mikheev
Subject Re: [HACKERS] I want to change libpq and libpgtcl for better handling of large query results
Date
Msg-id 34B27D23.6B2C765A@sable.krasnoyarsk.su
Whole thread Raw
In response to Re: [HACKERS] I want to change libpq and libpgtcl for better handling of large query results  (Peter T Mount <psqlhack@maidast.demon.co.uk>)
Responses Re: [HACKERS] I want to change libpq and libpgtcl for better handling of large query results  (Peter T Mount <psqlhack@maidast.demon.co.uk>)
List pgsql-hackers
Sorry, just to clear things:

> We were talking about some changes to the protocol. Perhaps, we could do
> something like changing it so it sends the result in blocks of tuples,
> rather than everything in one block. Then, in between each packet, an ACK
              ^^^^^^^^^^^^^^^^^^^^^^^

Backend sends tuples one by one - just after executor gets next tuple
from upper plan, backend sends this tuple to client-side.

> or CAN style packet could be sent to the backend, either asking for the
> next, or canceling the results.

Vadim

pgsql-hackers by date:

Previous
From: The Hermit Hacker
Date:
Subject: Re: [HACKERS] Postgres acl (fwd)
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Postgres acl (fwd)