How It's Made

How It's Made

Adopting PgCat: A Nextgen Postgres Proxy

Authors: Mostafa Abdelraouf, Zain Kabani, Andrew Tanner In this post, we’ll be talking about PgCat, an open-source Postgresql Proxy that we have been using in production and contributing to. It provides connection pooling, load-balancing, and replica failover for our Postgresql clusters. At Instacart, we use Postgresql for the vast majority of our database needs. We can squeeze a lot of performance out of a single…

Mar 13, 2023