Scaling Postgres Episodes Page 3
Episodes on how best to scale your PostgreSQL relational database.
Scaling Postgres Episode 245 ENUMs vs Check Constraints, Faceting With Roaring Bitmaps, Better Scaling, In DB Business Logic
In this episode of Scaling Postgres, we discuss ENUMs vs. check constraints, querying table facets with roaring bitmaps, a better way to handle scaling and whether you should store your business logic in Postgres.
Scaling Postgres Episode 244 Index Merge vs Composite, Transparent Column Encryption, Trusted Language Extensions, WAL Archive Module
In this episode of Scaling Postgres, we discuss merging indexes vs. a composite index, implementing transparent column encryption, developing trusted language extensions, and reviewing the WAL archive module.
Scaling Postgres Episode 242 Reduce Replication Lag, Explain Parameterized Query, PostGIS Day, Multiple PgBouncers
In this episode of Scaling Postgres, we discuss how PG15 helps reduce replication lag, how to get the parameters used in prepared statements, PostGIS Day and how to use multiple pgbouncers.