[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