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 :)
> 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