Scaling Postgres Episodes

Episodes on how best to scale your PostgreSQL relational database.

Scaling Postgres Episode 148 Hash Indexes | Int Float Numeric Types | Postgres 14 Features | Data Science

In this episode of Scaling Postgres, we discuss hash indexes, the int, float and numeric data types, features coming in Postgres 14 and data science in Postgres.

Scaling Postgres Episode 147 DBMS of the Year | Better Data Migrations | Idle Connection Impact | Security Implementation Guide

In this episode of Scaling Postgres, we discuss PostgreSQL as the DBMS of the year, running better data migrations, the impact of idle connections and a security implementation guild.

Scaling Postgres Episode 146 Active-Active & Federated | Memory Speed | Table Rewrite Causes | PostgreSQL Shibboleth

In this episode of Scaling Postgres, we discuss setting up active-active instances with federation, the impact of memory speed, the causes of table rewrites and the Postgres shibboleth.

Scaling Postgres Episode 145 PgMiner Botnet | Collation Index Corruption | postgresql.conf | Custom Data Types

In this episode of Scaling Postgres, we discuss the PGMiner botnet attack, how collation changes can cause index corruption, managing your postgresql.conf and implementing custom data types.

Scaling Postgres Episode 144 Postgres Migration | Bulk Data Loading | Updates vs. Upgrades | UUID Benchmarks

In this episode of Scaling Postgres, we discuss a Mongo to Postgres migration, the best way to bulk load data, running an update vs. an upgrade and benchmarks for UUIDs.

Scaling Postgres Episode 143 Microsoft SQL Server Compatible | Time Series Performance | Feature Casualties | BLOB Cleanup

In this episode of Scaling Postgres, we discuss Microsoft SQL server compatibility, the performance of time series DBs, DB feature casualties and how to clean up BLOBs.

Scaling Postgres Episode 142 Insert vs. Update | Select * Performance | Debezium Set Up | Standardizing Data

In this episode of Scaling Postgres, we discuss inserts vs. updates, select * performance, how to set up Debezium and methods to standardize data.

Scaling Postgres Episode 141 Unattended Upgrade | ARM Benchmarks | Exploration | PostGIS Performance

In this episode of Scaling Postgres, we discuss an unattended upgrade, ARM Postgres benchmarks, how to explore new databases and PostGIS performance.

Scaling Postgres Episode 140 Replication Conflicts | Postgres Governance | pg_crash | MobilityDB

In this episode of Scaling Postgres, we discuss replication conflicts, how Postgres is governed, a pg_crash utility and tracking temporal spatial data with Mobility.

Scaling Postgres Episode 139 Weekly News | Full-Text Search Performance | pg_cron | Bulk Data Loading

In this episode of Scaling Postgres, we discuss Postgres weekly news, full-text search performance, enhancements to pg_cron and the best way to bulk load data.

Next Page