Hi, > Can anybody highlight what would be the impact of removing RESET ALL > from reset_query_list on pgpool or the database? > > We want to change this parameter from: > > reset_query_list = 'ABORT; RESET ALL; SET SESSION AUTHORIZATION DEFAULT' to > > reset_query_list = 'ABORT; SET SESSION AUTHORIZATION DEFAULT' > > We want the db connection to stay in the same session where it had > connected so as all queries go to one db where the updates are going. > > We are using slony, and once we have done an update or insert on the > db (master). We want the consecutive queries to go on the master even > after the transaction is closed. Will the above change help?
I don't think so. That way you will just end up having unclean connections to the database (i.e. cached plans, prepared statements not freed up, etc). Cheers -- Matteo Beccati OpenX - http://www.openx.org _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
