I'm working on application, that is similar to hotsanic or munin, cacti (it is system and network graphing tool)
I want to store data to postgreSQL.
I have a group of servers and a set of plugins. On every server run a diferent subset of plugins.
Every plugin return in time loop two number: time and value. (For example at 9:00:05 is 80% disk space free.)
Database size will very huge with lots of inserts, because
number of servers: 200 and number of plugins: 200
values for one server and one plugin in a few year about 500.000
(for last 14 days are stored every 5 sec.)
total: 20.000.000.000 values
Data are read-only.
What is the best way to store this data?
I think data model.
Thank you for any help.
Im sorry for my english.