Wishes for PostgreSQL 6.4

Tom Lane wrote:
>
> 6.4-BETA1 doesn't work with Tcl 8.*. The current snapshot does though.
> Also I think a BETA2 tarball should be out today or tomorrow.

It's just fine. I'll wait for it.
I just wanted to test 6.4 BETA against PgAccess and maybe make some
improvements to PgAccess in order to release a new version of PgAccess
with 6.4

It's there something "Libpgtcl now gets async notifies from libpq(Tom)".

What means that ? Is there something that could improve PgAccess ?
The most important thing that could improve PgAccess would be another
implementation of pg_select.

For the moment, pg_select is issuing a "select" statement to backend IS
WAITING FOR ALL DATA TO COME, and then process the tcl loop.
It would be smarter to do something like that :

pg_select : "command sent to backend"
loop
wait for another tuple to come
if (end_of_records) break
process tcl loop script
endofloop

any chance to implement such a behavior in the future ?

Under a real multitasking environment and working with a server across a
network, this would reduce the time of processing selects that could be
executed in the same time that data is coming through the wire. Also,
will be memory consumption reduction, because every tuple can be
released after tcl loop processing, instead of buffering the WHOLE query
result in the local memory.
--
Constantin Teodorescu
FLEX Consulting Braila, ROMANIA