News for hackers. Stuff that matters.
Re:Citus 12: Schema-based sharding for PostgreSQL by hans_castorp on Tuesday July 18, 2023 @03:31PM (#36778011)
Schemas are namespaces (actually called that internally in Postgres).

The SQL standard defines a two level namespace hierarchy. A single "instance" of contains multiple catalogs and each catalog contains multiple schemas (and each schema then contains objects like tables, views, types, functions etc).

Many database products use the term "database" instead of "catalog" e.g. in Postgres and SQL Server. But "schema" is used quite uniformly. MySQL's "databases" are in fact "schemas" though.

Re:Citus 12: Schema-based sharding for PostgreSQL by pickledish on Tuesday July 18, 2023 @03:34PM (#36778048)
Whew boy, that's a more sizable hierarchy than I thought was going on under the hood lol, I guess I've got some reading to do. TY for the pointers!
Re:Citus 12: Schema-based sharding for PostgreSQL by somat on Wednesday July 19, 2023 @03:34AM (#36783160)
I always vaguely wonder why no one allowed a full hierarchical schema path. I expect it is probably because "the standard sez one level of schema only"