News for hackers. Stuff that matters.
Re:Citus 12: Schema-based sharding for PostgreSQL by metadat on Tuesday July 18, 2023 @03:46PM (#36778185)
Does Oracle support anything like this? Or any other DBMS in widespread use, for that matter?

The promise behind this approach to DB sharding has great potential. Simultaneously impressive, novel, and badass.

Re:Citus 12: Schema-based sharding for PostgreSQL by brightball on Tuesday July 18, 2023 @06:48PM (#36780067)
I watched a Citus demo a few months back and it blew me away. I hear upgrades are the big challenge.
Re:Citus 12: Schema-based sharding for PostgreSQL by krab on Wednesday July 19, 2023 @04:41AM (#36783558)
Not really. It's comparable to a regular Postgres upgrade.

But you can screw it up - see https://github.com/citusdata/citus/discussions/6934

Re:Citus 12: Schema-based sharding for PostgreSQL by isoos on Tuesday July 18, 2023 @07:45PM (#36780474)
Depends on the definition of widespread use, but e.g. CockroachDB and YugabyteDB offer scaling of a subset of Postgresql features (and extending on the cluster capabilities).

Nevertheless, Citus is now a promising open source alternative.

Re:Citus 12: Schema-based sharding for PostgreSQL by sokols on Wednesday July 19, 2023 @01:23AM (#36782398)
There is Oracle RAC Sharding, but AFAIK it does it works only at a partition level.
Re:Citus 12: Schema-based sharding for PostgreSQL by ksec on Wednesday July 19, 2023 @10:14AM (#36786714)
Something like Vitess / PlanetScale?