I am going to design database for a large company with multiple branches. I am using PostgreSQL.
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?