this post was submitted on 05 Jul 2023

16 points (100.0% liked)

PostgreSQL

668 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

16

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

you are viewing a single comment's thread
view the rest of the comments

[–] 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