PostgreSQL Inside
约 1 分钟阅读
Inside
- www.postgresql.org/docs/current/catalog-pg-class.html
- JSON 1GB 限制，压缩前
- pg_table_size, pg_relation_size, pg_total_relation_size
- total_relation_size = table_size + index_size
- table_size = relation_size + toast_size
- external_size = toast_size + index_size
- www.postgresql.org/docs/current/storage-file-layout.html
- 参考
- postgrespro/zsonGitHubpostgrespro/zson
- 压缩 JSONB
- postgrespro/zsonGitHubpostgrespro/zson
- www.postgresql.org/docs/current/functions-admin.html
关联信息
反向链接、本文链接的其他页面和外部资料。
参考资料
GitHub1 条
- postgrespro/zsongithub.com/postgrespro/zson
其他外链3 条
- www.postgresql.org/docs/current/catalog-pg-class.htmlwww.postgresql.org/docs/current/catalog-pg-class.html
- www.postgresql.org/docs/current/functions-admin.htmlwww.postgresql.org/docs/current/functions-admin.html
- www.postgresql.org/docs/current/storage-file-layout.htmlwww.postgresql.org/docs/current/storage-file-layout.html