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 0

March 08, 2021 00:17:16
Episode Cover

Citus Open Source, Time Series Performance, Subscripting Updates, target_session_attrs | Scaling Postgres 155

In this episode of Scaling Postgres, we discuss Citus 10 open source, time series performance in native Postgres, using subscripting for updates and new...

Listen

Episode 192

November 23, 2021 00:12:39
Episode Cover

Foreign Key Indexes, Graph Queries, Linux Huge Pages, Text Column Size | Scaling Postgres 192

In this episode of Scaling Postgres, we discuss if foreign keys should have indexes, how to run graph queries, how to configure Linux huge...

Listen

Episode 121

July 06, 2020 00:16:33
Episode Cover

Fantastic Data Types, Domain Data Types, Insert Performance, Row Differences | Scaling Postgres 121

In this episode of Scaling Postgres, we discuss fantastic data types, custom domain data types, improving insert performance and how to query row differences....

Listen