Scaling Postgres

In this episode of Scaling Postgres, we discuss how to generate shaped sample data, track changes between Postgres versions, identify missed bottlenecks and use different index types. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/199-shaped-sample-data-version-changes-missed-bottlenecks-indexes-for-newbies/

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-compres...

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/

In this episode of Scaling Postgres, we discuss automatic indexing, function pipelines, with hold cursors and the different query scans. To get the show notes as well as get notified of new episodes, visit:  https://www.scalingpostgres.com/episodes/188-automatic-indexing-function-pipelines-with-hold-cursors-query-scans/

In this episode of Scaling Postgres, we discuss one method to shard a database, federating your database, the benefits of configuring linux HugePages and performance tuning. To get the show notes as well as get notified of new episodes, visit:  https://www.scalingpostgres.com/episodes/187-sharding-federation-linux-hugepages-performance-tuning/

In this episode of Scaling Postgres, we discuss select for update, the pgx framework to generate extensions, cool additions to Postgres 14 and full-text search. To get the show notes as well as get notified of new episodes, visit:  https://www.scalingpostgres.com/episodes/186-select-for-update-pgx-framework-cool-additions-full-text-search/

In this episode of Scaling Postgres, we discuss the release of Postgres 14, how best to use JSON, why are your indexes not being used and sequence gaps. To get the show notes as well as get notified of new episodes, visit:  https://www.scalingpostgres.com/episodes/185-postgres-14-released-using-json-not-using-indexes-sequence-gaps/

In this episode of Scaling Postgres, we discuss Postgres 14 RC1, little improvements in PG14, an index advisor and how to handle 1 million insert statements. To get the show notes as well as get notified of new episodes, visit:  https://www.scalingpostgres.com/episodes/184-postgres-14-rc1-little-things-index-advisor-million-inserts/

In this episode of Scaling Postgres, we discuss one cause of broken indexes, Postgres trademark issues, percentiles vs. averages and logical replication improvements. To get the show notes as well as get notified of new episodes, visit:   https://www.scalingpostgres.com/episodes/183-broken-indexes-trademark-issues-percentile-vs-average-logical-improvements/

In this episode of Scaling Postgres, we discuss having boundless text fields, revoking public schema permissions, less index bloat in PG14 and comparing hardware performance. To get the show notes as well as get notified of new episodes, visit:   https://www.scalingpostgres.com/episodes/182-boundless-text-revoked-permissions-index-bloat-hardware-performance/

In this episode of Scaling Postgres, we discuss connection scaling, how to cache your sequences, a message queuing implementation and the harms of subtransactions. To get the show notes as well as get notified of new episodes, visit:   https://www.scalingpostgres.com/episodes/181-connection-scaling-cached-sequences-message-queuing-harmful-subtransactions/

In this episode of Scaling Postgres, we discuss how to use aggregate filters, the importance of vacuum with insert-only tables, how to fix out-of-sync sequences and faster functional index options. To get the show notes as well as get notified of new episodes, visit:   https://www.scalingpostgres.com/episodes/180-aggregate-filters-insert-only-vacuum-out-of-sync-sequences-functional-indexes/

In this episode of Scaling Postgres, we discuss how to use foreign data wrappers, compression available in timescaledb, working with fuzzy search and describing Postgres query execution. To get the show notes as well as get notified of new episodes, visit:   https://www.scalingpostgres.com/episodes/179-foreign-data-wrapper-timescale-compression-fuzzy-search-query-execution/

In this episode of Scaling Postgres, we discuss new releases for Postgres & pgbouncer, have a performance discussion, describe the different index types and how to use them. To get the show notes as well as get notified of new episodes, visit:   https://www.scalingpostgres.com/episodes/178-postgres-releases-performance-discussion-index-types-index-power-use/

In this episode of Scaling Postgres, we discuss ways to work around the planner, working with grouping sets, using a lateral join and not-so-easy Postgres issues. To get the show notes as well as get notified of new episodes, visit:   https://www.scalingpostgres.com/episodes/177-planner-workarounds-grouping-sets-lateral-join-not-so-easy/

In this episode of Scaling Postgres, we discuss JSONB vs. window functions, a Postgres security checklist, implementing full-text search and using NFL timeseries data. To get the show notes as well as get notified of new episodes, visit:   https://www.scalingpostgres.com/episodes/176-jsonb-vs-window-functions-security-checklist-full-text-search-nfl-timeseries/

In this episode of Scaling Postgres, we discuss the current status of zheap, the gaps in sequences, how to efficiently paginate and how to set up patroni with etcd and haproxy. To get the show notes as well as get notified of new episodes, visit:   https://www.scalingpostgres.com/episodes/175-zheap-status-sequence-gaps-efficient-pagination-set-up-patroni/