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

Episode 268 • June 04, 2023 • 00:11:38
Faster Copy, psql Variables, backup_label, Bad Encoding | Scaling Postgres 268
Scaling Postgres
Faster Copy, psql Variables, backup_label, Bad Encoding | Scaling Postgres 268

Jun 04 2023 | 00:11:38

/

Hosted By

Creston Jamison

Show Notes

 

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.

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

https://www.scalingpostgres.com/episodes/268-faster-copy-psql-variables-backup_label-bad-encoding/

Other Episodes

Episode 335

September 29, 2024 • 00:18:32
Episode Cover

Postgres 17 Released! | Scaling Postgres 335

In this episode of Scaling Postgres, we discuss the release of Postgres 17, b-tree performance gains, logical replication enhancements and different levels of performance...

Listen

Episode 424

July 05, 2026 • 00:15:22
Episode Cover

Too Many Table Danger | Scaling Postgres 424

In this episode of Scaling Postgres, we discuss the dangers of too many tables, don't worry about extending checkpoint_timeout, a disaster recovery process, and...

Listen

Episode 419

May 31, 2026 • 00:15:39
Episode Cover

The Dynamic Duo? | Scaling Postgres 419

In this episode of Scaling Postgres, we go over the architecture of Multigres (Vitess for Postgres), pgBackRest's status, pg_flight_recorder and general SQL optimizations. To...

Listen