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

[Garry Saddington]

> 
> 
> 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