News for hackers. Stuff that matters.
Re:Citus 12: Schema-based sharding for PostgreSQL by pickledish on Tuesday July 18, 2023 @03:38PM (#36778094)
Ah, interesting ok

> You can have the same table definition, within the same database, defined multiple times (each in a different schema) and each holding different data.

So in this respect, each table within a schema indeed already acts like a "shard" of the overall table

Is this enforced? Like, if I create a table "messages" in schema A and a table "messages" in table B, must they have the same columns/column types, or is that just convention

Re:Citus 12: Schema-based sharding for PostgreSQL by mulander on Tuesday July 18, 2023 @03:45PM (#36778171)
They can be different, as long as your application can handle them being different (which makes sense for microservices as an example).
Re:Citus 12: Schema-based sharding for PostgreSQL by pickledish on Tuesday July 18, 2023 @03:49PM (#36778219)
I see! Fascinating, thanks for the help :)