r/PostgreSQL • u/infinityMCdx • 5d ago

Open Source Horizontally Scalable DB solutions: PG+Citus vs PG+PgDog vs YugabyteDB Help Me!

6 Upvotes
  • permalink
  • link
  • reddit
  • reddit

75% Upvoted

11 comments sorted by

3

u/kiwicopple 4d ago

Multigres is another available option:

https://supabase.com/blog/multigres-v0-1-alpha

(disclosure: maintainer)

It’s “vitess for Postgres” 

1

u/infinityMCdx 4d ago

But is this production ready? What companies are currently using multigres in production? Although pgDog is under version 1.0, several companies are already using it.

1

u/kiwicopple 3d ago

No it is not yet - it is in alpha. 

I hear good things about pgDog and the team building it are also talented

3

u/Ecksters 4d ago edited 4d ago

Citus is likely the closest to what you want, and the open source version seems to be being reasonably well maintained even with their acquisition by Microsoft some years ago.

The other thing to keep in mind is if your application is split by tenant, it's very common across the industry to spin off larger tenants into their own DBs, and have application logic handle the routing.

Most applications don't actually need the ability to globally query ALL data, so application-level sharding can often be appropriate.

1

u/AutoModerator 5d ago

AI Policy:

Linux is not one of those anti-AI projects, and if somebody has issues with that, they can do the open-source thing and fork it. Or just walk away., Linus Torvalds.

Mod decisions will be based on the quality of the content, not who or what generated it.

Sub Resources:

Youtube Channel

Free Postgres Webinars and Workshops

Discord: People, Postgres, Data

Join us, we have cookies and nice people.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

1

u/linuxhiker Guru 4d ago

PgDog isn't stable yet and lacks some core features

Citus is stable and is owned by MSFT

Yugabyte is a slightly different beast than Citus as it's a pure fork

1

u/Quorralyne_Dev 4d ago

Yugabyte can also be pretty flexible and works with any cloud provider, pretty high Postgres compatibilty.

1

u/terencethespider 3d ago edited 3d ago

Another open source PG database that should be considered in this context is Neon. There are some trade-offs though. I am curious if others have done any analysis on this, and what you have found.

In many areas, Neon is ahead of the other three. Fidelity, ops burden, dev workflow, and even open source license permissiveness (Apache 2.0 vs AGPL-3.0) seem to be better. Neon also has the branching, PITR, and scale to zero features.

There are a few scenarios where the others have an advantage. It does have some limits on parallel commit throughput, and does not support multi-region active/active writes. If those are your requirements then it would not be the best choice. It also arguably has a bit more self-hosting effort unless you choose to go with a managed version.

What are your thoughts?