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 :)
By large and small we are referring to the amount of data each schema holds currently. They can grow over time and some of them may become very big while others will remain small (storage wise).