Faster Copy, psql Variables, backup_label, Bad Encoding | Scaling Postgres 268

To get the show notes as well as get notified of new episodes, visit:

In this episode of Scaling Postgres, we discuss faster COPY in Postgres 16, how to use psql variables, the importance of backup_label and issues with bad character encoding.

Want to learn more about Postgres performance?

Timestamps:
00:00 - Intro
01:01 - How bulk loading with COPY can be 300% times faster in Postgres 16 Beta 1
02:19 - Variables in psql, how to use them?
03:23 - Do I Really Need That backup_label File?
04:34 - ERROR: invalid byte sequence – Fix bad encoding in PostgreSQL
06:24 - PgBouncer 1.19.1
06:45 - PostgreSQL for the SQL Server DBA: Transaction Isolation and Table Bloat
08:04 - SQL:2023 is out
08:24 - PostgreSQL compile times
08:55 - New Site, New Partman
09:27 - pgBackRest SFTP support
09:38 - Disaster Recovery for PostgreSQL on Kubernetes
09:56 - SVG Images from Postgres
10:27 - Parallelism
10:41 - Carlos Chapi
10:51 - The Making of Avalon in Dragon Ruby with James Stocks | Rubber Duck Dev Show 87
11:13 - Outro

#postgres #postgresql