On Mon, Sep 26, 2005 at 11:50:01PM +0200, [EMAIL PROTECTED] wrote: > > David Fetter <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote! ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend