Unlogged Tables, pg_stat_io, Type Constraints, Text Types | Scaling Postgres 253

Episode 253 February 19, 2023 00:16:25
Unlogged Tables, pg_stat_io, Type Constraints, Text Types | Scaling Postgres 253
Scaling Postgres
Unlogged Tables, pg_stat_io, Type Constraints, Text Types | Scaling Postgres 253

Feb 19 2023 | 00:16:25

/

Hosted By

Creston Jamison

Show Notes

In this episode of Scaling Postgres, we discuss working with unlogged tables, the new pg_stat_io feature, handling complex type constraints and choosing the best text type.

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

https://www.scalingpostgres.com

Other Episodes

Episode 268

June 04, 2023 00:11:38
Episode Cover

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

  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...

Listen

Episode 92

December 02, 2019 00:13:17
Episode Cover

Book Sales, B-tree Boost, More Postgres 12, Using pgBackRest | Scaling Postgres 92

In this episode of Scaling Postgres, we discuss book sales, boosts to b-tree indexes, more Postgres 12 features and how to setup and use...

Listen

Episode 174

July 19, 2021 00:15:54
Episode Cover

Lateral Joins, Generating JSON, dbcritic, Fetch First Rows | Scaling Postgres 174

In this episode of Scaling Postgres, we discuss understanding lateral joins, generating JSON with Postgres, the dbcritic utility, and fetch first rows vs. limit....

Listen