[pgpool-general: 2039] Re: pgpool replication mode
ishii at postgresql.org
Thu Aug 15 21:04:42 JST 2013
>> of page 21-22.
> That is a great help, thank you. Which system would you recommend then?
>>> 2/How are things like nextval handled so that each backend is in synch? Especially when selects are load balanced.
>> SELECTs including nextval etc. are treated as if they are write
>> queries. i.e. they are load balanced.
> Should that be 'not load balanced' or am I misunderstanding?
Sorry, I wanted to say "they are not load balanced".
> Do you have to set the blacklist for this treatment of nextval to function correctly?
Yes. However, that is already set in the default config file.
black_function_list = 'currval,lastval,nextval,setval'
SRA OSS, Inc. Japan
More information about the pgpool-general