R
R
Rrooom2014-11-18 11:45:24
PostgreSQL
Rrooom, 2014-11-18 11:45:24

How to calculate Postgresql data volume?

I did not find information on how to calculate how much the database will take?
I would like to know after what number of records one hard disk will no longer be enough.
And in general, there is data, on what amount of data what server resources are needed?
Well, there is a clean base. It occupies 300 meters. And in a year, statistics will ask for half a terabyte, and in two years one storage will not be enough. How to calculate?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
M
Melkij, 2014-11-18
@Rrooom

Only insert/select - direct dependence on tables, their fields and indexes.
As soon as update/delete appears, it is impossible to name the result. Due to MVCC, vacuum operation, application duration requirements, and update/delete intensity, the size of the data on disk can significantly exceed the size of the dump of the same data.
IMHO, it doesn't make sense. Set monitoring, launch into battle, see statistics and trend. You can immediately see how fast the database grows when the disk space runs out, when (which is much more likely) - iops.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question