一家大型公司的PostgreSQL数据库设计 [英] PostgreSQL database design for a large company

问题描述

我要为具有多个分支机构的大型公司设计数据库.我正在使用PostgreSQL.

示例:
我为所有分支创建一个数据库. 10年后，数据库大小太大.
我当时想知道数据库的性能是否降低.

是否可以为所有年份的数据维护一个数据库?

谢谢.

I am going to design database for a large company with multiple branches. I am using PostgreSQL.

Example:
I create a single database for all branches. After 10 years, database size is too large.
I want to know, at that time, if the performance of the database is reduced or not.

Is it possible to maintain a single database for all years of data?

Thank you.

推荐答案

任何答案都将是主观的，但我会尝试提供建议.

为什么太大?性能是否超出了预期范围，还是磁盘空间问题?数据标准化了吗，您使用的索引正确吗?

是因为它以相同的速度增长而过大，还是突然经历了增长，现在突显了它的缺点?

Any answer is going to be subjective, but I''ll try offer advice.

Why is it too large? Has performance gone out the window, or is it a disk space issue? Is the data normalized, are you using proper indexes?

Is it too large because it has been growing at the same rate, or has it suddenly experienced growth that now highlights its faults?

这篇关于一家大型公司的PostgreSQL数据库设计的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！