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

From Bruce Momjian
Subject Re: A bad behavior under autocommit off mode
Date
Msg-id 200303262256.h2QMuvr08983@candle.pha.pa.us
Whole thread Raw
In response to Re: A bad behavior under autocommit off mode  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: A bad behavior under autocommit off mode  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane wrote:
> 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.

My basic idea was using INFO-like message to send the SET change
information.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073
 



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: A bad behavior under autocommit off mode
Next
From: Tom Lane
Date:
Subject: Re: A bad behavior under autocommit off mode