We are going to design database for a large company with multi branches. I am using PostgreSQL
For example,
I create a single database for all branches. After 10 years, database size is too large. I want to know ,at that time, the performance of the database is reduced or not.
Is it possible to maintain in a single database for all years of data?