Re: A bad behavior under autocommit off mode - Mailing list pgsql-hackers

From Tom Lane
Subject Re: A bad behavior under autocommit off mode
Date
Msg-id 7231.1048719327@sss.pgh.pa.us
Whole thread Raw
In response to Re: A bad behavior under autocommit off mode  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: A bad behavior under autocommit off mode
List pgsql-hackers
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Tom Lane wrote:
>> Bruce Momjian <pgman@candle.pha.pa.us> writes:
>>> How about sending an INFO or special taged message to the client when
>>> there is a GUC change, and have report_changes as a GUC variable that
>>> controls it?
>> 
>> Having such a variable would break the client libraries that need the
>> information.  They won't stop needing the info just because some DBA
>> thinks it's a good idea to save a few bytes of bandwidth ...

> You could configure it so once it is set by the client, only the client
> can change it, meaning it doesn't read from postgresql.conf.

I'm not seeing the point, though.  The amount of bandwidth involved is
insignificant, so there's no value in turning it off.  AFAICT Peter's
objection to adding this is complexity, not bandwidth --- and adding a
control knob as you suggest will only make it even more complex.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: A bad behavior under autocommit off mode
Next
From: Bruce Momjian
Date:
Subject: Re: A bad behavior under autocommit off mode