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 338

October 20, 2024 00:17:03
Episode Cover

JSON Goodies In Postgres 17 | Scaling Postgres 338

In this episode of Scaling Postgres, we discuss the JSON goodies in Postgres 17, trigger recursion, pg_dump as backup and pg_timeseries columnar performance. To...

Listen

Episode 214

May 08, 2022 00:19:29
Episode Cover

Backup Compression, Postgres IO, Parquet Files, pg_stat_monitor | Scaling Postgres 214

In this episode of Scaling Postgres, we discuss parallel server-side backup compression, IO in Postgres, parquet files and the new pg_stat_monitor extension. To get...

Listen

Episode 366

May 18, 2025 00:14:46
Episode Cover

20,000 Times Faster Order By Limit | Scaling Postgres 366

In this episode of Scaling Postgres, we discuss a top ten dangerous Postgres issues list, importing and exporting statistics, more Postgres 18 beta features...

Listen