5mins of Postgres E21: Server-side backup compression with LZ4 and Zstandard in Postgres 15
Today, we're going to talk about backup improvements in Postgres 15. Postgres 15 beta1 came out a couple of weeks ago and we’re looking into LZ4 and Zstandard compression, as well as the removal of the exclusive backup mode
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
📑 What we have discussed in this episode of 5mins of Postgres:
Postgres 15 on PostgreSQL.org: https://www.postgresql.org/docs/15/re...
pg_start_backup in Postgres 14: https://www.postgresql.org/docs/14/fu...
pg_backup_start in Postgres 15: https://www.postgresql.org/docs/15/fu...
Server-Side LZ4 Backup Compression - blog post by Robert Haas: https://rhaas.blogspot.com/2022/02/se...
pgbench - Benchmarking for PostgreSQL: https://www.postgresql.org/docs/curre...
Parallel Server-Side Backup Compression - blog post by Robert Haas: https://rhaas.blogspot.com/2022/05/pa...
Robert Haas ton Twitter: / robertmhaas
adding 'zstd' as a compression algorithm - Message by Robert Haas on PostgreSQL.org: https://www.postgresql.org/message-id...
5mins of Postgres E11: MERGE in Postgres 15, and how it compares to INSERT ON CONFLICT: https://pganalyze.com/blog/5mins-post...
5mins of Postgres E13: New SQL/JSON and JSON_TABLE features in Postgres 15: https://pganalyze.com/blog/5mins-post...
5mins of Postgres E19: Speeding up sort performance in Postgres 15: https://pganalyze.com/blog/5mins-post...