开发者

PostgreSQL: Performance penalty for joining two tables in separate schemas

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

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜