From: L J Bayuk <ljb220@mindspring.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: pgin.tcl pg_exec_prepared slow (was: Released...)
Date: Sun, 11 Jul 2004 21:33:04 -0400
Message-ID: <20040712013304.GA574@bxlbisnugqvi.mindspring.com> (raw)
In-Reply-To: <739.1089418076@sss.pgh.pa.us>
References: <24110.1087945736@sss.pgh.pa.us>
<Pine.LNX.4.21.0406302310340.12226-100000@ponder.fairway2k.co.uk>
<20040706010731.GA15183@bxlbisnugqvi.mindspring.com>
<14766.1089081827@sss.pgh.pa.us>
<20040708011244.GA331@bxlbisnugqvi.mindspring.com>
<739.1089418076@sss.pgh.pa.us>
On Fri, Jul 09, 2004 at 08:07:56PM -0400, Tom Lane wrote:
> L J Bayuk <ljb220@mindspring.com> writes:
> > I just haven't decided
> > whether to flush before reading, or flush after all messages that need a
> > response (I think: Startup, PasswordMessage, Query, Sync, CopyDone, and
> > FunctionCall are the ones I use).
>
> You seem to have quite missed my point. If you decide to flush on the
> basis of flush-after-certain-message-types-are-sent, then the types to
> flush after are precisely Sync and Flush. If you think you want
> something different, you are wrong and should think again (or more
> likely, insert Flush messages into the outgoing stream at the places
> where you want a flush to occur). There is no point in flushing after
> any other message type because the backend won't flush its response.
>...
Yes, I must be missing your point, unless you are talking only about the
Extended Query mode. Surely outside of Extended Query mode (Startup, Basic
Query mode, Function Call) the client must flush output after (at least)
the messages I listed above. That's what I get from the protocol
documentation, what works in practice, and network traces.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: ljb220@mindspring.com, tgl@sss.pgh.pa.us
Subject: Re: pgin.tcl pg_exec_prepared slow (was: Released...)
In-Reply-To: <20040712013304.GA574@bxlbisnugqvi.mindspring.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox