Today, we are looking at generate_series and pgebench (and its initialization options) to generate test data for Postgres. We also show the new random_normal function in Postgres 16.
Find the article on our blog here:
pganalyze.com/blog/5mins-post...
Learn more about pganalyze:
pganalyze.com
pganalyze.com/newsletter
/ pganalyze
Check out the pganalyze library for eBooks, webinars, and more:
pganalyze.com/resources
📑 What we have discussed in this episode of 5mins of Postgres:
Generating lots of test data with Postgres, fast and faster - by Kaarel Moppel
kmoppel.github.io/2022-12-23-...
Kaarel Moppel on GitHub
github.com/kmoppel
pgbench on postgresql.org
www.postgresql.org/docs/curre...
pgbench Initialization options
www.postgresql.org/docs/curre...
Waiting for PostgreSQL 16 - Invent random_normal() to provide normally-distributed random numbers - by depesz
www.depesz.com/2023/01/11/wai...
Benchmarking multi-column, covering and hash indexes in Postgres
pganalyze.com/blog/5mins-post...