Comment by denysvitali
9 months ago
I know this is just a small feature and probably a less meaningful one compared to the rest of the project - but for me being able to use pgdog as a way to redirect reads to read replicas and writes to the primary (w/o doing that in code) is a huge plus. Many applications out there do not support R/W splits, and having something that does that for you (at the proxy level) has always brought speed improvements for me in the past.
Such a cool project, good job Lev!
You can already do that with pgcat (author’s second project) https://github.com/postgresml/pgcat
Maybe I worded my comment in the wrong way - but this feature is already available (although still with small issues in corner cases) in pgdog :)
Thank you! We used Makara for this at Instacart, but eventually grew to using other languages, e.g. Python, Go, etc. and reinventing the wheel every time was pretty tedious.