| ▲ | igor47 3 months ago | |
Why are GCR and pgbouncer incompatible? Could you run a pgbouncer instance in GCR? | ||
| ▲ | seabrookmx 3 months ago | parent | next [-] | |
GCR assumes it's workload is HTTP, or a "job" (container that exits once it's task has completed). It scales on request volume and CPU, and the load balancer is integrated into the service. It's not obvious to me how you'd even run a "raw" TCP service like pgbouncer on it. | ||
| ▲ | czhu12 3 months ago | parent | prev [-] | |
I’m not an expert, but from what I understand, the standard set up is like: 4x(Web processes) -> 1x(pgbouncer) -> database This ensures that the pgbouncer instance is effectively multiplexing all the connections across your whole fleet. In each individual web process, you can have another shared connection pool. This is how we set it up | ||