docs.timescale.com-content icon indicating copy to clipboard operation
docs.timescale.com-content copied to clipboard

[Change] Add capacity planning information

Open wilfriedroset opened this issue 5 years ago • 1 comments

Change in content, appearance, or functionality? Add the appropriate label(s) -->>

Describe the change While researching information about TSDB solution ones might need to have capacity planning information. Obviously, this depends significantly on usecases but ballpark figures can help assess the solution, in this case timescaledb.

Based on the tutorial sample datasets one can have a disk space estimation:

devices_small=# \l+ devices_small
                                                    List of databases
     Name      |  Owner   | Encoding |   Collate   |    Ctype    | Access privileges |  Size   | Tablespace | Description
---------------+----------+----------+-------------+-------------+-------------------+---------+------------+-------------
 devices_big | tutorial | UTF8     | en_US.UTF-8 | en_US.UTF-8 |                   | 7661 MB | pg_default |
(1 row)

For 3,000 devices recorded over 10,000 time intervals, we have 30000000 datapoints for a total of 7661 MB.

TimescalDB's expert advices would be appreciated for that especially for RAM and CPU. We can find such documentation in several solutions:

Location(s)

I believe a dedicated page is best suited

How soon is this needed?

wilfriedroset avatar Nov 12 '20 15:11 wilfriedroset

Thank you for the suggestion @wilfriedroset! It's already on our radar and we're going to put it in our roadmap. I'll share the link when we publish the first version.

jonatas avatar Apr 28 '21 14:04 jonatas