PostgreSQL

643 readers

1 users here now

The world's most advanced open source relational database

Project

About (history)
Docs
Donate to PostgreSQL
Wiki
Planet PostgreSQL
IRC
Mailing lists:
- pgsql-announce
- pgsql-hackers (developers)
- pgsql-general
- pgsql-jobs
User Groups

Events

SEAPUG Summer BBQ, 6 July in Seattle
SFBA PostgreSQL Meetup, 12 July
Chicago PostgreSQL Meetup, 19 July
PGDay UK 2023, 12 September in London
PGConf 2023, 3-5 October in New York City
PGDay Israel 2023, 19 October
PGConf.EU 2023, 12-15 December in Prague

Podcasts

postgres.fm (feed)

Related Fediverse communities

c/SQL on programming.dev
#sql on Mastodon
#postgresql on Mastodon

founded 1 year ago

MODERATORS

Ategon

starman

jnovinger

has postgres got an official solution for sharding? (lemmy.world)

submitted 1 year ago by [email protected] to c/postgresql

6 comments fedilink hide all child comments

or is it only possible through add-ons/forks

top 5 comments

sorted by: hot top controversial new old

[–] towerful 4 points 1 year ago (1 children)

Considering clusters need a load balancer in front of them, I'm going to say only through add-ons.

You can shard a table on the same server (it's called partitioning).
Not something I have done, haven't needed to yet.

Beyond that, it's pgcat I believe, in which query sharding is still experimental.

HAProxy and PGBouncer can do load balancing for reads, but ultimately the cluster is single main for writes.
Supabases Supavisor is another beta release option for postgres connection routing, but it is VERY early in development. I think they are dog-fooding it tho. Certainly one I am keeping an eye on!

However, that is my limited experience opinion.
Happy to be told otherwise, hopefully I start a discussion!

[–] [email protected] 3 points 1 year ago (2 children)

thank you! I'm too tired to contribute to a discussion right now 😅

been experimenting with postgres to hopefully move to it eventually.

I use mariadb at the moment and they've been releasing pretty unreliable updates in recent years. Galera was nice with it, but had way too many issues.

[–] ndotb 4 points 1 year ago (1 children)

If you're looking for a mysql/maria drop-in replacement, then you may also want to look at tidb

postgres can do it, but it's kind of presented as lego blocks for a HA cluster and often requires making your own tooling if you want sophisticated features like placement index instances and rebalancing

[–] [email protected] 2 points 1 year ago* (last edited 1 year ago)

query optimization and the similar structure to SQL server with schemas pulls me towards postgres, got another system using SQL server with upwards of millions of records and need it to be fast and reliable

[–] towerful 3 points 1 year ago

I've been recently introduced to postgres from using supabase (I want a nice API and real-time database functionality, similar to firebase).
And I am more and more impressed at what postgres can do. It feels like cheating!

However, clustering and high availability is something I am working on learning. Certainly, it's more of a DB Admin type responsibility that I have ever dealt with (which is why I used to use firebase!)

load more comments