I have a couple Pgpool questions regarding running pgpool as a load balancer with Sony as the replicator.
Is there anyway to load balance selects to more than 2 servers? ex. 1 master with 2 slaves? Run multiple instances?
My understanding is that if you turn on the load balancing it will automatically do so for all servers.
Is there any way to tell a select (ex. with a function) to go only the master and not the slave?
Run it in a transaction with BEGIN;
Is there any way to tell a select query to only go to the slave?
That i don't know.
Sincerely,
Joshua D. Drake Command Prompt, Inc.
Thanks
---------------------------(end of broadcast)---------------------------TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
