PgCat

Infrastructure

connection pooler

SHOW HN2022

233points
54comments
#218of 2,570 in 2022
Top 9%of 2022 by points

How HN took it

MixedNo clear lean

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 HN
    • I'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 HN
    • This 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 HN
    • This 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 HN
    • Yep 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 HN
    • 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

Requests

  • Add retries on failed queries

    From 1 comment
  • 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 HN
    • 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 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 HN
    • This 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 HN
    • This 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

Category, keywords, summaries and labels on this page were made by AI (Thread Reader v2) and not checked by hand. Each point links to the comments it came from.

Add a badge to your READMEShown on HackerShow
[![Shown on HackerShow](https://hackershow.org/badge.svg)](https://hackershow.org/show/30267539)