How bulk loading with COPY can be 300% times faster in Postgres 16 Beta 1
Find the article on our blog here: https://pganalyze.com/blog/5mins-post...
In episode 70 of “5mins of Postgres” I want to talk about Postgres 16 Beta 1 being released and how one of its improvements can allow you to bulk load about 300% times faster with COPY. The reason for this being an improvement to relation extension locks.
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:
PostgreSQL 16 Beta 1 Released!
https://www.postgresql.org/about/news...
PostgreSQL 16 Beta 1 Release Notes
https://www.postgresql.org/docs/16/re...
PostgreSQL 16 Beta 1 is now available in Amazon RDS Database Preview Environment
https://aws.amazon.com/about-aws/what...
refactoring relation extension and BufferAlloc(), faster COPY - mailing list thread
https://www.postgresql.org/message-id...
bufmgr: Introduce infrastructure for faster relation extension - Commit by Andres Freund
https://git.postgresql.org/gitweb/?p=...
hio: Use ExtendBufferedRelBy() to extend tables more efficiently - Commit by Andres Freund
https://git.postgresql.org/gitweb/?p=...
Wait Events of Type Lock - extend event
https://www.postgresql.org/docs/curre...
Waiting for Postgres 16: Logical decoding on standbys
https://pganalyze.com/blog/5mins-post...
Waiting for Postgres 16: Running EXPLAIN on any query (even with $1 parameters!)
https://pganalyze.com/blog/5mins-post...
Waiting for Postgres 16: Buffer cache hit ratio and I/O times in pg_stat_io
https://pganalyze.com/blog/5mins-post...
Vacuum Cost Limit and Parallel Aggregate improvements in Postgres 16
https://pganalyze.com/blog/5mins-post...
Waiting for Postgres 16: Cumulative I/O statistics with pg_stat_io
https://pganalyze.com/blog/pg-stat-io
Postgres 16: Surviving without a superuser & reserved_connections
https://pganalyze.com/blog/5mins-post...
Using pgbench to load data faster, and the random_normal function in PG16
https://pganalyze.com/blog/5mins-post...