If you are interested in connection pooling maybe you will find interesing SPQR too https://github.com/pg-sharding/spqr Currently it's our experiment to build pooling-based PostgreSQL sharding.
Scalable PostgreSQL Connection Pooler
11–20 of 91 posts
Re: Scalable PostgreSQL Connection Pooler
#12Re: Scalable PostgreSQL Connection Pooler
#13I appreciate the work going on to make high quality poolers for Postgres...I just really wish the work was done in-core so we could have built in connection pooling, or the work done to make grabbing a new connection as cheap as if you were using a pooler. It sucks to have to add complexity to your stack to fix a "deficiency" in Postgres' design. Still, I am glad there is effort put into project even if I selfishly w…
Re: Scalable PostgreSQL Connection Pooler
#14I appreciate the work going on to make high quality poolers for Postgres...I just really wish the work was done in-core so we could have built in connection pooling, or the work done to make grabbing a new connection as cheap as if you were using a pooler. It sucks to have to add complexity to your stack to fix a "deficiency" in Postgres' design. Still, I am glad there is effort put into project even if I selfishly w…
Re: Scalable PostgreSQL Connection Pooler
#15Re: Scalable PostgreSQL Connection Pooler
#16Has anyone used Yandex Cloud [0] in production?, How does it compare to DigitalOcean, AWS, GCP and others? Also the tech from Yandex such as Clickhouse [1] is really interesting, as they recently spun it out of Yandex. [0] https://cloud.yandex.com/en/ [1] https://clickhouse.com/
Re: Scalable PostgreSQL Connection Pooler
#17FWIW I maintain Odyssey and will be happy to answer any question regarding it. Actually there was just a CVE-triggered release... I really hope to release more often with more new functionality. If you are interested in connection pooling maybe you will find interesing SPQR too https://github.com/pg-sharding/spqr Currently it's our experiment to build pooling-based PostgreSQL sharding.
Re: Scalable PostgreSQL Connection Pooler
#18i mean i see valgrind, vim, etc in there. this would be a very fat dockerfile.
It seems that way - https://github.com/yandex/odyssey/issues/29#issuecomment-764...
>But it's hard to "bless" some "official" as image: no one from active contributors uses Odyssey in Docker to maintain it thoroughly.
OTOH pgbouncer docker images are rock-solid in production.
Very quickly updated to track upstream.
e.g. the Bitnami ones - https://hub.docker.com/r/bitnami/pgbouncer/ which also have CVE security scans https://quay.io/repository/bitnami/pgbouncer?tab=tags
Microsoft releases an officially supported k8s sidecar of pgbouncer - https://hub.docker.com/_/microsoft-azure-oss-db-tools-pgboun...
Re: Scalable PostgreSQL Connection Pooler
#19Does anyone know if you can specify parent roles (group-style non-login roles)? That's something I've wanted from pgbouncer, so instead of making settings at the user level (applications) I could make them at the group level (e.g. apiv2-readonly).
Re: Scalable PostgreSQL Connection Pooler
#20What is the use case for this?