[pgpool-general: 2039] Re: pgpool replication mode

Tatsuo Ishii ishii at postgresql.org
Thu Aug 15 21:04:42 JST 2013

>> http://www.pgecons.org/wp-content/uploads/2013/04/Introducing_PostgreSQL_Enterprise_Consortium_activities.pdf
>> 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'
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

More information about the pgpool-general mailing list