5mins of Postgres E50: Using pgbench to load data faster, and the random_normal function in PG16
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:
https://pganalyze.com/blog/5mins-post...
Learn more about pganalyze:
https://pganalyze.com
https://pganalyze.com/newsletter
/ pganalyze
Check out the pganalyze library for eBooks, webinars, and more:
https://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
https://kmoppel.github.io/2022-12-23-...
Kaarel Moppel on GitHub
https://github.com/kmoppel
pgbench on postgresql.org
https://www.postgresql.org/docs/curre...
pgbench Initialization options
https://www.postgresql.org/docs/curre...
Waiting for PostgreSQL 16 – Invent random_normal() to provide normally-distributed random numbers - by depesz
https://www.depesz.com/2023/01/11/wai...
Benchmarking multi-column, covering and hash indexes in Postgres
https://pganalyze.com/blog/5mins-post...