Scaling Postgres

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/

In this episode of Scaling Postgres, we discuss understanding lateral joins, generating JSON with Postgres, the dbcritic utility, and fetch first rows vs. limit. To get the show notes as well as get notified of new episodes, visit:   https://www.scalingpostgres.com/episodes/174-lateral-joins-generating-json-dbcritic-fetch-first-rows/

In this episode of Scaling Postgres, we discuss how to delay replication, working with materialized view permissions, paranoid configuration options and addressing memory overcommit. To get the show notes as well as get notified of new episodes, visit:   https://www.scalingpostgres.com/episodes/173-delayed-replication-materialized-view-permissions-paranoid-postgres-memory-overcommit/

In this episode of Scaling Postgres, we discuss tracking per-operation explain analyze, Postgres 14 contribution stats, parallel execution on foreign servers and incremental view maintenance. To get the show notes as well as get notified of new episodes, visit:   https://www.scalingpostgres.com/episodes/172-per-operation-explain-pg14-contributions-foreign-parallel-execution-incremental-view-mainte...

In this episode of Scaling Postgres, we discuss practical partitioning, understanding pg_repack, explaining buffers and enforcing multi-row constraints. To get the show notes as well as get notified of new episodes, visit:   https://www.scalingpostgres.com/episodes/171-practical-partitioning-understanding-pg_repack-explaining-buffers-multi-row-constraints/

In this episode of Scaling Postgres, we discuss Redis vs. Postgres, working in the hard quadrant, how Postgres optimizes joins and working with materialized views. To get the show notes as well as get notified of new episodes, visit:   https://www.scalingpostgres.com/episodes/170-redis-vs-postgres-hard-quadrant-optimizing-joins-materialized-views/

In this episode of Scaling Postgres, we discuss only using bigint, high availability, Postgres autocommit and synchronized sequential scans. To get the show notes as well as get notified of new episodes, visit:   https://www.scalingpostgres.com/episodes/169-use-bigint-high-availability-autocommit-synchronized-sequential-scans/

In this episode of Scaling Postgres, we discuss managing autovacuum, better JSON in Postgres 14, how to avoid redundant updates and operating system tuning. To get the show notes as well as get notified of new episodes, visit:   https://www.scalingpostgres.com/episodes/168-managing-autovacuum-better-json-avoiding-updates-os-tuning/

In this episode of Scaling Postgres, we discuss how to interpret explain analyze, the best ways to load data in bulk, how to limit rows affected by update or delete and using pg_buffercache. To get the show notes as well as get notified of new episodes, visit:   https://www.scalingpostgres.com/episodes/167-interpreting-explain-analyze-bulk-data-loading-limiting-update-delete-pg_buffercache/

In this episode of Scaling Postgres, we discuss the release of Postgres 14 Beta 1, different PG 14 improvements, choosing the best type of primary key and using composite keys. To get the show notes as well as get notified of new episodes, visit:  https://www.scalingpostgres.com/episodes/166-postgres-14-beta1-pg14-improvements-best-primary-keys-composite-keys/

In this episode of Scaling Postgres, we discuss the newest Postgres releases, implementing a data warehouse, using exclusion operators and setting up read-only users. To get the show notes as well as get notified of new episodes, visit:  https://www.scalingpostgres.com/episodes/165-postgres-releases-data-warehouses-exclusion-operators-read-only-users/

In this episode of Scaling Postgres, we discuss selecting random rows quickly, faster distinct queries, how replication handles temp and unlogged tables and how to terminate connections. To get the show notes as well as get notified of new episodes, visit:  https://www.scalingpostgres.com/episodes/164-fast-random-rows-fast-distinct-queries-temp-unlogged-tables-terminating-connections/