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 405

February 22, 2026 00:16:59
Episode Cover

Out of Cycle Releases | Scaling Postgres 405

In this episode of Scaling Postgres, we discuss an out of cycle Postgres release, a Supabase downtime incident, optimizing top K queries and how...

Listen

Episode 139

November 08, 2020 00:12:37
Episode Cover

Weekly News, Full-Text Search Performance, pg_cron, Bulk Data Loading | Scaling Postgres 139

In this episode of Scaling Postgres, we discuss Postgres weekly news, full-text search performance, enhancements to pg_cron and the best way to bulk load...

Listen

Episode 265

May 14, 2023 00:16:47
Episode Cover

pg_stat_statements, Transaction ID Wraparound, Consultant Knowledge, CitusCon | Scaling Postgres 265

  In this episode of Scaling Postgres, we discuss different ways to use pg_stat_statements, how to handle transaction ID wraparound, consultant knowledge and all the...

Listen