Scaling Postgres

In this episode of Scaling Postgres, we discuss how to monitor DML & DDL progress, using more SQL, one way to handle replication slot fail-over, and recent Postgres contributors.

To get the show notes as well as get notified of new episodes, visit:

https://www.scalingpostgres.com/episodes/198-monitoring-progress-more-sql-replication-slot-failover-postgres-contributors/

In this episode of Scaling Postgres, we discuss including buffers with explain analyze, having a healthier Postgres DB, the events of 2021 and aspiring for greater high availability solutions.

To get the show notes as well as get notified of new episodes, visit: 

https://www.scalingpostgres.com/episodes/197-explain-analyze-buffers-healthier-postgres-2021-review-high-availability-aspirations/

In this episode of Scaling Postgres, we discuss easily writing a recursive CTE, the zheap undo capability, high availability considerations and fast ways to load data.

To get the show notes as well as get notified of new episodes, visit: 

https://www.scalingpostgres.com/episodes/196-easy-recursive-cte-zheap-undo-high-availability-loading-data/

In this episode of Scaling Postgres, we discuss Aurora vs. Postgres, surprising transaction behavior, write-only & read-only database connections and indexing best practices.

To get the show notes as well as get notified of new episodes, visit: 

https://www.scalingpostgres.com/episodes/195-auroora-vs-postgres-surprising-transactions-write-only-read-only-indexing-advice/

In this episode of Scaling Postgres, we discuss going slower to go faster, GIN indexes, collation stability and features of PG14 and beyond.

To get the show notes as well as get notified of new episodes, visit: 

https://www.scalingpostgres.com/episodes/194-go-faster-gin-indexes-collation-stability-pg14-beyond/

In this episode of Scaling Postgres, we discuss using entity-attribute-value designs, new JSON subscripting capabilities, the mysql-fdw support for aggregate pushdowns and new regex functions in PG 15.

To get the show notes as well as get notified of new episodes, visit: 

https://www.scalingpostgres.com/episodes/193-entity-attribute-value-design-json-subscripting-mysql-fdw-push-down-new-regex/

In this episode of Scaling Postgres, we discuss if foreign keys should have indexes, how to run graph queries, how to configure Linux huge pages and the benefits as well as text size similarities.

To get the show notes as well as get notified of new episodes, visit: 

https://www.scalingpostgres.com/episodes/192-foreign-key-indexes-graph-queries-linux-huge-pages-text-column-size/

In this episode of Scaling Postgres, we discuss new releases of Postgres due to a man-in-the-middle vulnerability, the high availability solution pg_auto_failover, lesser known Postgres features and LZ4 compression.

To get the show notes as well as get notified of new episodes, visit: 

https://www.scalingpostgres.com/episodes/191-man-in-the-middle-pg_auto_failover-lesser-known-features-lz4-compression/

In this episode of Scaling Postgres, we discuss the open sourcing of Babelfish, deconstructing the Postgres planner, when to avoid exist & not exist and having fun with SQL.

To get the show notes as well as get notified of new episodes, visit: 

https://www.scalingpostgres.com/episodes/190-hello-babelfish-planner-deconstruction-exist-not-exist-fun-with-sql/

In this episode of Scaling Postgres, we discuss the downsides of indexes, TCP keep alive options, developing with Postgres as your DB and learning PL/pgSQL.

To get the show notes as well as get notified of new episodes, visit: 

https://www.scalingpostgres.com/episodes/189-index-downsides-tcp-keep-alive-development-with-postgres-learning-plpgsql/