PgCat
Infrastructure
connection pooler
SHOW HN2022
How HN took it
8 positive, 4 neutral or asking, 1 mixed, 2 critical, out of 15 comments about the project. Thread score +0.32.
Idea: 4 for, 1 againstExecution: 2 for, 1 againstPerformance: 1 for, 0 against
The thread, comment by comment
Each row is a top-level comment and its replies, in HN's order. Select a cell to open that comment on HN.
positive neutral or mixed critical about another commenter or something else the maker
What HN said
What people liked
Excitement about Rust rewrite and small, lean codebase
From 3 comments
I am really excited to see this project. I can't tell you how many times my team at work has hit a limitation with pgbouncer and swore up and down we should just re-write it in…
dkhenry on HNI'm really impressed by how lean this code base is. Is PgBouncer also this lean? Looks like auth is the only thing left here then, aside from maybe some more testing? Very cool…
jjice on HNThis is actually pretty amazing. I wouldn't normally trust a single author implemented project to sit between my application and my database, since that is a rather critical…
montanalow on HN
Sharding and failover features are interesting
From 2 comments
Sharding and failover support is really cool indeed! But I've always struggled to understand the use cases of pgbouncer. In most cases, you want to front your database with a…
potamic on HNThis is really interesting and exciting to see. Though it probably has a ways to go before being production ready. We've seen to date a few other efforts at connection poolers…
craigkerstiens on HN
Objections
Alpha quality with few tests and not production ready
From 2 comments
Being in Rust or not the code has 0 tests, write arbitrary bytes, hard code values etc ... looks like more a PoC project that something that going to replace pgbouncer any time…
Thaxll on HNYep the readme is pretty clear it's a POC "Alpha: don't use in production just yet." That said I've struggled with more than my fair share of pgbouncer misconfigurations and…
mmontagna9 on HN
Performance behind PgBouncer
From 1 comment
The performance is currently behind pg_bouncer though.. ofcouse the project is much more early stages, just want your thoughts. Where should new people contribute or can help…
dmingod666 on HN
Name clashes with existing pgcat project
From 2 comments
You might want to consider a different name, as there's already a pgcat project which appears to be a logical replication extension to augment native logical replication.…
bonesmoses on HN1. rename the project, there's already pgcat. 2. bring it to production level, i would love it :D 3. Are there things like gis or jsonb which would break with it, or does it just…
deknos on HN
Requests
Add retries on failed queries
From 1 comment
Thank you! Retries are on the road map.
levkk on HN
Better stats for monitoring
From 1 comment
This is so awesome. For those wondering why a pooler is needed, Tl;DR containers. It's much more normal to have hundreds of containers running an application configured to have…
everfrustrated on HN
Rename the project
From 2 comments
1. rename the project, there's already pgcat. 2. bring it to production level, i would love it :D 3. Are there things like gis or jsonb which would break with it, or does it just…
deknos on HNYou might want to consider a different name, as there's already a pgcat project which appears to be a logical replication extension to augment native logical replication.…
bonesmoses on HN
Questions
Does it work with GIS or JSONB types
From 1 comment
1. rename the project, there's already pgcat. 2. bring it to production level, i would love it :D 3. Are there things like gis or jsonb which would break with it, or does it just…
deknos on HN
Why use a pooler instead of client-side pooling
From 1 comment
Sharding and failover support is really cool indeed! But I've always struggled to understand the use cases of pgbouncer. In most cases, you want to front your database with a…
potamic on HN
Alternatives named
PgBouncer
From 2 comments
So I thought it would be kind of cool to take Pgbouncer to the next level. I've been using it with large database clusters for a while and it's been spectacular, but it does have…
levkk on HNThis is really interesting and exciting to see. Though it probably has a ways to go before being production ready. We've seen to date a few other efforts at connection poolers…
craigkerstiens on HN
Odyssey
From 1 comment
Alternative: yandex/odessey https://github.com/yandex/odyssey
jimmyed on HN
Citus
From 2 comments
(Ozgun from Citus / Microsoft) Hi there, thanks for mentioning Citus. Could you share a bit more about the user experience you're looking for with sharding? With Citus, you…
ozgune on HNThis is really interesting and exciting to see. Though it probably has a ways to go before being production ready. We've seen to date a few other efforts at connection poolers…
craigkerstiens on HN
Vitess
From 1 comment
Most application never reaches the scale that requires sharding. I'll just use the quote from the notion blog as arguments against automated sharding solution like Vitess. >>…
dikei on HN