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 11

May 07, 2018 00:12:13
Episode Cover

Serializable, JSON & JSONB, Fast Data Loading, PG11 Features | Scaling Postgres 11

In this episode of Scaling Postgres, we review articles covering serializable, JSON & JSONB data types, fast data loading with Ruby and Postgres 11...

Listen

Episode 25

August 13, 2018 00:13:14
Episode Cover

generate_series, PG11 Partitioning, GPU Queries | Scaling Postgres 25

In this episode of Scaling Postgres, we review articles covering graphing with generate_series, partitioning in Postgres 11 and GPUs for queries. To get the...

Listen

Episode 218

June 05, 2022 00:17:03
Episode Cover

PG14 Index Bug, View Permissions, Logical Replication Conflicts, AlloyDB Under the Hood | Scaling Postgres 218

In this episode of Scaling Postgres, we discuss a severe bug with index creation in Postgres 14, view permissions options, dealing with logical replication...

Listen