Hacker News: levkk

New comment by levkk in "PgDog is funded and coming to a database near you"

levkk — Thu, 11 Jun 2026 01:25:34 +0000

fwiw, we support cross-shard transactions. They are not magic though, just good old 2pc and a bit of coordination.

New comment by levkk in "PgDog is funded and coming to a database near you"

levkk — Wed, 10 Jun 2026 21:31:33 +0000

Thanks!

New comment by levkk in "PgDog is funded and coming to a database near you"

levkk — Wed, 10 Jun 2026 20:34:56 +0000

This reminds me of college. We had to cite our own papers from prior semesters or risk getting kicked out for plagiarism. I don't miss those days :)

New comment by levkk in "PgDog is funded and coming to a database near you"

levkk — Wed, 10 Jun 2026 20:16:32 +0000

Thanks! Yup...to be expected. If you know, you know, and have the scars to prove it :)

New comment by levkk in "PgDog is funded and coming to a database near you"

levkk — Wed, 10 Jun 2026 17:39:45 +0000

Yup!

New comment by levkk in "PgDog is funded and coming to a database near you"

levkk — Wed, 10 Jun 2026 17:30:05 +0000

Two big ones:

1. Control plane to manage multi-node deployments; "works out of the box" experience to make PgDog easy to deploy and use

2. QoS (quality of service): automatically block bad queries from taking down the database

Last but not least, you get SLA-backed support from us (up to P0).

New features are broken down into two categories:

1. Sharding / running Postgres at scale: always open source.

2. Infra management / making it easy to run PgDog at scale: enterprise.

New comment by levkk in "PgDog is funded and coming to a database near you"

levkk — Wed, 10 Jun 2026 17:19:10 +0000

Good thing we support HA as well: https://docs.pgdog.dev/features/load-balancer/

Load balancer with health checks and failover, works out of the box. :) Battle-tested at this point too, so could be worth a look.

New comment by levkk in "PgDog is funded and coming to a database near you"

levkk — Wed, 10 Jun 2026 17:05:49 +0000

I see you met Sage, our newest founding engineer :) If you're not having fun at your job...

In all seriousness, we review every single line of code that goes in and only people who work for PgDog Inc are allowed to merge.

New comment by levkk in "PgDog is funded and coming to a database near you"

levkk — Wed, 10 Jun 2026 16:58:21 +0000

Yup. We support schema-based sharding: https://docs.pgdog.dev/configuration/pgdog.toml/sharded_sche...

New comment by levkk in "PgDog is funded and coming to a database near you"

levkk — Wed, 10 Jun 2026 16:46:58 +0000

Not the place and not the time, but we are building an enterprise edition that "just works" out of the box. Not saying that the open source experience cannot be better - it always can and we'll keep improving. What you've experienced is definitely a known issue with our specific implementation of passthrough auth. Scram made things a bit harder, since we can't validate user's passwords at login time anymore (that's what makes scram secure fwiw).

We'll get there.

New comment by levkk in "PgDog is funded and coming to a database near you"

levkk — Wed, 10 Jun 2026 16:40:14 +0000

Always is. Marketing is not our strong suit (only engineers here). We'll get better at it.

New comment by levkk in "PgDog is funded and coming to a database near you"

levkk — Wed, 10 Jun 2026 16:38:42 +0000

> 8 smaller boxes handling ~500GB each and then one medium box for the proxy?

That's exactly right. Get in touch (lev@pgdog.dev), happy to help or at the very least tell you what current works (or doesn't) so you know what your options are.

New comment by levkk in "PgDog is funded and coming to a database near you"

levkk — Wed, 10 Jun 2026 16:37:02 +0000

This is not an extension, it's a proxy! Very different. You can deploy it anywhere already without having to wait for upstreaming or your cloud provider adding support for it. It's one of the two reasons why we built it this way, the other being performance (it's much faster to do this in the proxy than inside Postgres).

New comment by levkk in "PgDog is funded and coming to a database near you"

levkk — Wed, 10 Jun 2026 16:00:42 +0000

Yes, except it doesn't have any cross-dependencies on the same volume, so the uptime here should be higher.

New comment by levkk in "PgDog is funded and coming to a database near you"

levkk — Wed, 10 Jun 2026 15:46:27 +0000

OLAP means different things to different people. For us, it's just making sure your admin dashboard keeps working basically:

  SELECT tenant_id, COUNT(clicks)
  FROM users
  GROUP BY tenant_id
  ORDER BY 2 DESC
  LIMIT 25;

Performance is a side effect - definitely needed and we'll do everything we can, but we are not competing with ClickHouse or Snowflake - just trying to make sharded Postgres work with your app.

New comment by levkk in "PgDog is funded and coming to a database near you"

levkk — Wed, 10 Jun 2026 15:35:10 +0000

Two schools of thought:

1. Let it crash. Increase the RAM, try again.

2. Page to disk (swap), make it slow but ultimately work.

Both have their trade-offs. There is no free lunch here.

New comment by levkk in "PgDog is funded and coming to a database near you"

levkk — Wed, 10 Jun 2026 15:33:46 +0000

The docker compose example is just a demo. I don't know anyone who runs Postgres with docker compose / swarm in prod :) But yes, happy to add volumes so it seems more real.

New comment by levkk in "PgDog is funded and coming to a database near you"

levkk — Wed, 10 Jun 2026 14:52:59 +0000

We do, just buried deep in our blog: https://pgdog.dev/blog/pgdog-vs-citus

The same old processes vs. threads debate, plus having the ability to scale the coordinator past a single machine. So, if you're OLTP, definitely consider PgDog. OLAP - Citus still wins because of its advanced query engine. We'll get there.

New comment by levkk in "PgDog is funded and coming to a database near you"

levkk — Wed, 10 Jun 2026 14:52:01 +0000

Depends. Only pooling, very little. Load balancing/sharding needs to parse queries, so a bit more. Could go up to a GB per pod, sometimes more if you have a lot of unique SQL queries (unique by text, not by parameters). We cache query ASTs to avoid parsing them on each request - that's the bulk of memory usage.

New comment by levkk in "PgDog is funded and coming to a database near you"

levkk — Wed, 10 Jun 2026 14:50:56 +0000

Old benchmark, but still good: https://pgdog.dev/blog/pgbouncer-vs-pgdog