Podcast Episodes
Back to Search
DBMS of the Year, Better Data Migrations, Idle Connection Impact, Security Implementation Guide | Scaling Postgres 147
Episode 147
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.
To get the show…
Published on 4 years, 11 months ago
Active-Active & Federated, Memory Speed, Table Rewrite Causes, PostgreSQL Shibboleth | Scaling Postgres 146
Episode 146
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.
To get the sh…
Published on 4 years, 11 months ago
PgMiner Botnet, Collation Index Corruption, postgresql.conf, Custom Data Types | Scaling Postgres 145
Season 145
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.
To get t…
Published on 5 years ago
Postgres Migration, Bulk Data Loading, Updates vs. Upgrades, UUID Benchmarks | Scaling Postgres 144
Episode 144
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.
To get the show notes as well…
Published on 5 years ago
Microsoft SQL Server Compatible, Time Series Performance, Feature Casualties, BLOB Cleanup | Scaling Postgres 143
Episode 143
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.
To get the show notes as well …
Published on 5 years ago
Insert vs. Update, Select * Performance, Debezium Set Up, Standardizing Data | Scaling Postgres 142
Episode 142
In this episode of Scaling Postgres, we discuss inserts vs. updates, select * performance, how to set up Debezium and methods to standardize data.
To get the show notes as well as get notified of new…
Published on 5 years ago
Unattended Upgrade, ARM Benchmarks, Exploration, PostGIS Performance | Scaling Postgres 141
Episode 141
In this episode of Scaling Postgres, we discuss an unattended upgrade, ARM Postgres benchmarks, how to explore new databases and PostGIS performance.
To get the show notes as well as get notified of …
Published on 5 years, 1 month ago
Replication Conflicts, Postgres Governance, pg_crash, MobilityDB | Scaling Postgres 140
Episode 140
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.
To get the show notes as well as …
Published on 5 years, 1 month ago
Weekly News, Full-Text Search Performance, pg_cron, Bulk Data Loading | Scaling Postgres 139
Episode 139
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.
To get the show notes as well as get no…
Published on 5 years, 1 month ago
Scaling Connections, TimescaleDB, Time-series Gaps, Red & Golden Signals | Scaling Postgres 138
Episode 138
In this episode of Scaling Postgres, we discuss scaling connections, the release of TimescaleDB 2.0, how to find time-series gaps and monitoring RED & Golden signals.
To get the show notes as well as…
Published on 5 years, 1 month ago