Hi,

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.

Best regards
Marek Fiala

ServerID int
PluginID int
DataValue ???

Then you'd have a server table and a plugin table. Storing a 4 byte int vs a string is the only way to do high data volume.