Click here to Skip to main content
15,851,395 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
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.
Posted
Updated 24-Feb-11 1:27am
v2
Comments
voloda2 24-Feb-11 12:07pm    
You should provide more information. It heavily depends on data stored inside the database (such as images etc).

1 solution

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?
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900