Get the latest tech news
How to Create (Lots of) Sample Time-series Data with PostgreSQL (2021)
Use generate_series to see how TimescaleDB uses PostgreSQL's rock-solid foundation to build a scalable, fully extensible, powerful time-series database.
As the makers of TimescaleDB, we often need to quickly create lots of sample time-series data to demonstrate a new database feature, run a benchmark, or talk about use cases internally. Although using real data from your current application would be great (and ideal), knowing how to quickly create a representative time-series dataset using varying cardinalities and different lengths of time is a helpful - and advantageous - skill to have. However, if the function you're calling generates lots of temporary data internally before producing a result, be aware that it could perform more slowly and consume more resources on your database server.
Or read this on Hacker News