[pgpool-general: 2037] Re: pgpool replication mode
Garry Saddington
garry at scholarpack.com
Thu Aug 15 16:39:39 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? Do you have to set the blacklist for this treatment of nextval to function correctly?
Kind Regards
Garry
More information about the pgpool-general
mailing list