Latest Episodes
244
Index Merge vs Composite, Transparent Column Encryption, Trusted Language Extensions | Scaling Postgres 244
In this episode of Scaling Postgres, we discuss merging indexes vs. a composite index, implementing transparent column encryption, developing trusted language extensions, and reviewing...
243
IN vs ANY, Ghost Conditions, Percentage Calculations, Variadic Unnest | Scaling Postgres 243
In this episode of Scaling Postgres, we discuss how PG15 helps reduce replication lag, how to get the parameters used in prepared statements, PostGIS...
242
Reduce Replication Lag, Explain Parameterized Query, PostGIS Day, Multiple PgBouncers | Scaling Postgres 242
In this episode of Scaling Postgres, we discuss how PG15 helps reduce replication lag, how to get the parameters used in prepared statements, PostGIS...
241
Postgres 15.1, Postres 10 Retrospective, Reducing Replication Lag, Listen & Notify | Scaling Postgres 241
In this episode of Scaling Postgres, we discuss the release of Postgres 15.1, a Postgres 10 retrospective, how to reduce replication lag and using...
240
Forced Sequential Scans, Table Renaming, Terminology, PGSQL Phriday | Scaling Postgres 240
In this episode of Scaling Postgres, we discuss how sequential scans can be forced, the best way to rename a table without downtime, different...
239
Shared Buffers, Compression Algorithm, Merge Command, Postgres Contributions | Scaling Postgres 239
In this episode of Scaling Postgres, we discuss how to set shared buffers, the different WAL compression algorithm options, how to use the merge...