Re: [HACKERS] statement logging / extended query protocol

On Mon, Sep 26, 2005 at 11:50:01PM +0200, simon(at)2ndquadrant(dot)com wrote:
>
> David Fetter <david(at)fetter(dot)org> wrote on 26.09.2005, 18:31:16:
> > On Sun, Sep 25, 2005 at 11:41:11PM -0400, Bruce Momjian wrote:
> > > Tom Lane wrote:
> > > > Bruce Momjian writes:
> > > > > OK. At this stage it should all just wait for 8.2.
> > > >
> > > > Haven't we already committed some feature changes in this
> > > > area? I dislike the idea of shipping a transient state just
> > > > because "we ran out of time". Once we ship 8.1, that will be
> > > > another behavior that we have to consider backwards
> > > > compatibility with. We should either fix it right, or revert
> > > > to the 8.0 behavior for this release.
> > >
> > > I documented in TODO what doesn't log properly in 8.1. I don't
> > > see how logging output has to be backward compatible.
> >
> > Dunno about this particular case, but not having
> > backward-compatible logging output has already broken pqa.
> > Proposal on logging to -hackers follows...
>
> Guys,
>
> The changes I initiated, were caused solely by the complete
> inability of PostgreSQL 8.0 log files to allow performance tuning
> for v3 protocol clients (i.e. JDBC as the main one). That's been a
> major obstacle for everybody I have talked to all year.

I agree that you fixed a bug, and I apologize for haring off on that
thread with a not-quite-related suggestion.

> I had no wish at all to alter logging, but neither did anyone else, so
> something had to be done. Regression to 8.0 way of doing things (i.e.
> no logging) is *not* an option unless we want to lose friends, rather
> than gain them. So, the log format needs changing... and we have no
> need for backwards compatibility.

Right.

> (pqa 1.5 is broken. It doesn't even run its sample 7.4 log file
> properly. Thats a separate issue to what the log file format is. I
> do like 1.4 though.)

pqa 1.5 works on log files from 8.0 if they're only prefixed with a
timestamp.

Cheers,
D
--
David Fetter david(at)fetter(dot)org http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778

Remember to vote!