postgresql postgres 中可以创建多少个模式
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/14893964/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
How many schemas can be created in postgres
提问by Arsalan T
While implementing solution to a multi tenant using postgres I needed an answer on how much the maximum schemas can reside in one postgres database.
在使用 postgres 为多租户实施解决方案时，我需要一个关于最大模式可以驻留在一个 postgres 数据库中的数量的答案。
回答by Pavel Stehule
We tested thousands schemas - with thousands tables without problem. There are a few known issues
我们测试了数千个模式 - 数千个表没有问题。有几个已知问题
- problems with GUI administration - slow start due read a complete object tree on start,
- problems with pg_dump - slow start of backup - needs lot of time for locking objects.
- GUI 管理的问题 - 由于在启动时读取完整的对象树而导致启动缓慢，
- pg_dump 的问题 - 备份启动缓慢 - 需要大量时间来锁定对象。
回答by Hafiz Hashim
You can have even thousands of schemas in your Postgres. And just take it as a folder that is helping you out to implement logical division of your data. You may also read this for reference: https://www.postgresql.org/message-id/[email protected]
您的 Postgres 中甚至可以有数千个模式。并将其作为一个文件夹，帮助您实现数据的逻辑划分。您也可以阅读本文以供参考：https: //www.postgresql.org/message-id/[email protected]
