开发者

PostgreSQL: Performance penalty for joining two tables in separate schemas

开发者 https://www.devze.com 2023-03-17 23:22 出处:网络
Is there a performance penalty when joining two tables in separate schemas (However in the same database).

Is there a performance penalty when joining two tables in separate schemas (However in the same database).

My physical model开发者_如何学Go has several distinct sections that fit nicely into their own schemas, however I occasionally need to join across schemas and I've been unable to find any information on if this has a negative performance impact.


No, a schema is just a namespace.

Performance might be different when tables (or their indexes) are stored on different tablespaces. One tablespace might be on a fast storage device, the other on a slow one. But that's your choice and has nothing to do with a schema.

0

精彩评论

暂无评论...
验证码 换一张
取 消