Scaling Postgres

By Creston JamisonTechnology

Scaling Postgres episodes

January 17, 2021 Hash Indexes, Int Float Numeric Types, Postgres 14 Features, Data Science | Scaling Postgres 148
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.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/148-hash-indexes-int-float-numeric-postgres-14-features-data-science/
12 min
January 10, 2021 DBMS of the Year, Better Data Migrations, Idle Connection Impact, Security Implementation Guide | Scaling Postgres 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 notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/147-dbms-of-the-year-better-data-migrations-idle-connection-impact-security-implementation-guide/
21 min
January 04, 2021 Active-Active & Federated, Memory Speed, Table Rewrite Causes, PostgreSQL Shibboleth | Scaling Postgres 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 show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/146-active-active-federated-memory-speed-table-rewrite-causes-postgresql-shibboleth/
15 min
December 20, 2020 PgMiner Botnet, Collation Index Corruption, postgresql.conf, Custom Data Types | Scaling Postgres 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 the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/145-pgminer-botnet-attack-collation-index-corruption-postgresqlconf-custom-data-types/
15 min
December 13, 2020 Postgres Migration, Bulk Data Loading, Updates vs. Upgrades, UUID Benchmarks | Scaling Postgres 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 as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/144-postgres-migration-bulk-data-loading-updates-vs-upgrades-uuid-benchmarks/
13 min
December 07, 2020 Microsoft SQL Server Compatible, Time Series Performance, Feature Casualties, BLOB Cleanup | Scaling Postgres 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 as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/143-microsoft-sql-server-compatible-time-series-performance-feature-casualties-blob-cleanup/
19 min
November 29, 2020 Insert vs. Update, Select * Performance, Debezium Set Up, Standardizing Data | Scaling Postgres 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 episodes, visit:
https://www.scalingpostgres.com/episodes/142-insert-vs-update-select-performance-debezium-set-up-standardizing-data/
14 min
November 23, 2020 Unattended Upgrade, ARM Benchmarks, Exploration, PostGIS Performance | Scaling Postgres 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 new episodes, visit:
https://www.scalingpostgres.com/episodes/141-unattended-upgrade-arm-benchmarks-exploration-postgis-performance/
11 min
November 15, 2020 Replication Conflicts, Postgres Governance, pg_crash, MobilityDB | Scaling Postgres 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 get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/140-replication-conflicts-postgres-governance-pg_crash-mobilitydb/
12 min
November 08, 2020 Weekly News, Full-Text Search Performance, pg_cron, Bulk Data Loading | Scaling Postgres 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 notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/139-weekly-news-full-text-search-performance-pg_cron-bulk-data-loading/
13 min

About Scaling Postgres

From the publisher's feed

Learn how to get the best performance and scale your PostgreSQL database with our weekly shows. Receive the best content curated from around the web. We have a special focus on content for developers…