Jamie Tufnell <diesql@googlemail.com> writes:
> Secondly, is there a companion tool to achieve this with pgbouncer?
> Note I have nothing against pgpool, just curious as we're already
> using pgbouncer in production.
If you mean distributing the read-only queries to more than one server
backend, you can use haproxy in TCP mode for that. Application talks to
pgbouncer, which talks to haproxy, which connects to PostgreSQL.
Please note that nothing there will triage the read-only queries apart
from your application, and the hot-standby PostgreSQL (which will error
out).
Regards,
--
dim