I've a pool of applications running django 1.6 with psycopg2 on top of a PGPool II with two backends PostgreSQL servers. But all queries (read and/or write) are going to master PostgreSQL even SELECT.

As we can see on PGPool II documentation, if we have read queries into transactions we need to hit some conditions to load balancing os send to master. I know that we have some points of the code that we have SELECT into a transaction but we also have simple SELECT queries which is going to master too.

I'm not sure if, and what, conditions we are hitting to send all queries to master.

Here the table with conditions for load balancing:

enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.