How to create (lots!) of sample time-series data with PostgreSQL generate_series()
summary
Shows how to use PostgreSQL's generate_series() (plus user-defined functions and built-in math functions) to synthesize large, realistic time-series datasets with varying cardinalities and durations. Demonstrates combining generate_series() with relational data and PostgreSQL math to model patterns for use cases such as sales or website visits, useful for demos, benchmarks, and reproducing query plans.
AI-written summary · about
related talks
51mPostgreSQL, The Time-Series Database You Want
49mPostgreSQL, The Time-Series Database You Actually Want
21mA Hands-on Experience with Complex SQL
34mSimple and Awesome Database Tricks
29mSELECT 'amazing_features' FROM "postgresql"
46mUse PostgreSQL to Step Up Your Game
53mEfficient Time Series with PostgreSQL
30mLesser known features of PostgreSQL