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 116

June 01, 2020 00:14:01
Episode Cover

Observer Effect, Partition Management, Tuple Freezing, Hung Transactions | Scaling Postgres 116

In this episode of Scaling Postgres, we discuss the observer effect with explain analyze, partition management, tuple freezing and sources of hung transactions. To...

Listen

Episode 292

November 26, 2023 00:13:13
Episode Cover

Companion Databases? | Scaling Postgres 292

In this episode of Scaling Postgres, we discuss using companion databases, multi-tenancy database design, whether SQL is good, and different transaction isolation levels. To...

Listen

Episode 318

June 02, 2024 00:17:54
Episode Cover

Postgres 17 Beta 1 Released | Scaling Postgres 318

In this episode of Scaling Postgres, we discuss all the new features in Postgres 17 Beta 1, some features that did not make it,...

Listen