Shows
Scaling PostgresPostgres 16 RC1, Bi-Directional Replication, All About Parameters, Foreign Keys & Polymorphism | Scaling Postgres 280In this episode of Scaling Postgres, we discuss the release of Postgres 16 RC1, implementing bi-directional replication, different ways you can set up Postgres parameters and how to handle polymorphism and foreign keys.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/280-postgres-16-rc1-bi-directional-replication-all-about-parameters-foreign-keys-polymorphism/
2023-09-0321 min
Scaling PostgresTPS Benchmark, Partition-wise Join & Aggregate, Partitioning Billions, Posgres 16 Features | Scaling Postgres 279
In this episode of Scaling Postgres, we discuss how pgbouncer can impact a TPS benchmark, partition-wise join & aggregate performance, partitioning a table with billions of rows and cool Postgres 16 features.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/279-tps-benchmark-partition-wise-join-partitioning-billions-postgres-16-features/
2023-08-2715 min
Scaling PostgresSqueeze Your System, One Million Connections, Indexing LIKE, pgvector HNSW | Scaling Postgres 278
In this episode of Scaling Postgres, we discuss how to squeeze the most out of your database, achieving one million connections to Postgres, how to use indexes with LIKE and pgvector HNSW index performance.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/278-squeeze-your-system-one-million-connections-indexing-like-pgvector-hnsw/
2023-08-2015 min
Scaling PostgresPostgres Releases, PostgreSQL Survey, Partitioning vs. Sharding, Bulk Loading | Scaling Postgres 277
In this episode of Scaling Postgres, we discuss new Postgres releases, taking the 2023 State of PostgreSQL survey, partitioning vs. sharding and the fastest way to do bulk loads.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/277-postgres-releases-postgresql-survey-partitioning-sharding-bulk-loading/
2023-08-1319 min
Scaling PostgresBRIN & Correlation, Poor Partitioning, 10 Beginner Tips, Table & Index Usage | Scaling Postgres 276
In this episode of Scaling Postgres, we discuss the importance of correlation with BRIN indexes, how partitioning can kill performance, 10 tips for beginners and how to track table and index usage.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/276-brin-correlation-poor-partitioning-10-beginner-tips-table-index-usage/
2023-07-3015 min
Scaling PostgresNo More Vacuum, Zero-Downtime Cut-Over, Network Impact, Not In Optimization | Scaling Postgres 275
In this episode of Scaling Postgres, we discuss getting rid of vacuum, how to do zero-downtime cut-overs, analyzing the impact of slow networks and seeing a not in optimization.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/275-no-more-vacuum-zero-downtime-cut-over-network-impact-not-in-optimization/
2023-07-2313 min
Scaling PostgresSubquery Performance, Avoid Update Locking, Column Changes, Outage Workshop | Scaling Postgres 274
In this episode of Scaling Postgres, we discuss subquery performance, how to avoid excessive locking when doing updates, how to change a columns datatype without excessive locking and lessons from an upgrade outage.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/274-subquery-performance-avoid-update-locking-column-changes-outage-workshop/
2023-07-1614 min
Scaling PostgresDebian / Ubuntu Packaging, ivfflat Indexes, In vs Any, View Logging | Scaling Postgres 273
In this episode of Scaling Postgres, we discuss how Debian & Ubuntu package Postgres, how ifflat indexes work, in vs any performance and how to log view usage.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/273-debian-ubuntu-packages-ivfflat-indexes-in-vs-any-view-logging/
2023-07-1015 min
Scaling PostgresPostgres 16 Beta 2, The Rise of Vectors, FDW Performance, Unused Indexes | Scaling Postgres 272
In this episode of Scaling Postgres, we discuss the release of Postgres 16 Beta 2, the rise of vectors and storing them, Foreign Data Wrapper performance and how to identify unused indexes.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/272-postgres-16-beta-2-rise-of-vectors-fdw-performance-unused-indexes/
2023-07-0314 min
Scaling Postgres30% Faster, UUID Downsides, Growing WAL, Processes vs. Threads | Scaling Postgres 271
In this episode of Scaling Postgres, we discuss how to get 30% faster performance, the downsides of UUIDs, having too much WAL and whether Postgres should use processes or threads.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/271-30-percent-faster-uuid-downsides-growing-wal-processes-vs-threads/
2023-06-2616 min
Scaling PostgresData Skew, Monitoring, Remote Access CSV, Documentation | Scaling Postgres 270
In this episode of Scaling Postgres, we discuss how to handle data skew, tools for Postgres monitoring, how to load data remotely and Postgres documentation.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/270-data-skew-monitoring-remote-access-csv-documentation/
2023-06-1814 min
Scaling PostgresUpgrade Struggles, Hyperloglog, PgBouncer Usage, Postgres Scaling | Scaling Postgres 269
In this episode of Scaling Postgres, we discuss Postgres upgrade struggles, how and why to use hyperloglog, using pgbouncer for session vs. transaction pooling, and methods to scale Postgres.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/269-upgrade-struggles-hyperloglog-pgbouncer-usage-postgres-scaling/
2023-06-1218 min
Scaling PostgresFaster Copy, psql Variables, backup_label, Bad Encoding | Scaling Postgres 268
In this episode of Scaling Postgres, we discuss faster COPY in Postgres 16, how to use psql variables, the importance of backup_label and issues with bad character encoding.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/268-faster-copy-psql-variables-backup_label-bad-encoding/
2023-06-0411 min
Scaling PostgresPostgreSQL 16 Beta 1, Rust Functions, Partitioning Memory Problems, Tags & Arrays | Scaling Postgres 267
In this episode of Scaling Postgres, we discuss the release of PostgreSQL 16 Beta 1, creating Rust functions with PL/Rust, memory problems related to partitioning and prepared statements, and modeling tags with arrays.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/267-postgres-16-beta-1-rust-functions-partitioning-memory-problems-tags-arrays/
2023-05-2816 min
Scaling PostgresPostgres Releases, Postgres Distributed, Privilege Template, Real-Time Dashboards | Scaling Postgres 266
In this episode of Scaling Postgres, we discuss new Postgres releases, EDB Postgres Distributed, a privilege template and real-time dashboards.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/266-postgres-releases-postgres-distributed-privilege-template-real-time-dashboard/
2023-05-2116 min
Scaling Postgrespg_stat_statements, Transaction ID Wraparound, Consultant Knowledge, CitusCon | Scaling Postgres 265
In this episode of Scaling Postgres, we discuss different ways to use pg_stat_statements, how to handle transaction ID wraparound, consultant knowledge and all the videos of CitusCon.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/265-pg_stat_statements-transaction-id-wraparound-consultant-knowledge-cituscon/
2023-05-1416 min
Scaling PostgresThe Worst Part, Pluggable Storage, A Busy System, Data Architecture | Scaling Postgres 264
In this episode of Scaling Postgres, we discuss the worst part of Postgres, the status of pluggable storage, what makes a busy system and methods for managing different data architectures.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/264-worst-part-pluggable-storage-busy-system-data-architecture/
2023-05-0717 min
Scaling PostgresLZ4 & ZSTD Compression, Avoiding Problems, Triggers Simplify, Indexes Can Hurt | Scaling Postgres 263
In this episode of Scaling Postgres, we discuss LZ4 and ZSTD pg_dump compression, how to avoid problems, can triggers simplify and indexes can hurt.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/263-lz4-zstd-compression-avoiding-problems-triggers-simplify-indexes-can-hurt/
2023-05-0119 min
Scaling Postgrespg_failover_slots, Standby Logical Decoding, Trusted Language Extensions, Postgres Package Manager | Scaling Postgres 262
In this episode of Scaling Postgres, we discuss the pg_failover_slots extension, how PG16 allows logical decoding on standbys, what are trusted language extensions and how a package manager has been built for them.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/262-pg_failover_slots-standby-logical-decoding-trusted-language-extensions-postgres-package-manager/
2023-04-2314 min
Scaling PostgresEasy Foreign Data Wrappers, JSONB Cheatsheet, Updating Cost Limit, Parallel Aggregate | Scaling Postgres 261
In this episode of Scaling Postgres, we discuss how to easily crate a foreign data wrapper to consume an API, present a convenient JSONB cheatsheet, changes to updating the vacuum cost limit and new parallel aggregates.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/261-easy-foreign-data-wrappers-jsonb-cheatsheet-updating-cost-limit-parallel-aggregate/
2023-04-1716 min
Scaling PostgresPL/Rust, Row Locks, Postgres Errors, SQL 2023 | Scaling Postgres 260
In this episode of Scaling Postgres, we discuss PL/Rust 1.0 release, row locks, Postgres errors and the new SQL 2023 standard.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/260-plrust-row-locks-postgres-errors-sql-2023/
2023-04-0912 min
Scaling PostgresRecovery Time, Lost Data, Production Ready, PG16 Highlights | Scaling Postgres 259
In this episode of Scaling Postgres, we discuss max_wal_size as it relates to recovery time, losing your data with collation changes, getting production ready and highlights coming in Postgres 16.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/258-logical-replication-database-antipatterns-max_wal_size-delete-vs-truncate/
2023-04-0213 min
Scaling PostgresLogical Replication, Database Antipatterns, max_wal_size Setting, Delete vs. Truncate | Scaling Postgres 258
In this episode of Scaling Postgres, we discuss use cases for logical replication, database anti-patterns, how to set max_wal_size and the difference between delete and truncate.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/258-logical-replication-database-antipatterns-max_wal_size-delete-vs-truncate/
2023-03-2708 min
Scaling PostgresAdopting PgCat, Time Bins, work_mem Settings, Bad Constraints | Scaling Postgres 257In this episode of Scaling Postgres, we discuss Instacart adopting PgCat, binning or bucketing your data by time, the best settings for work_mem and how to avoid bad check constraints.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/257-adopting-pgcat-time-bins-work_mem-settings-bad-constraints/
2023-03-2019 min
Scaling Postgres11TB WAL, pgec Writes, Patroni 3 & Citus, PostgREST | Scaling Postgres 256In this episode of Scaling Postgres, we discuss WAL growing to 11 Terabytes, pgec supporting writes, Patroni 3.0 & Citus for high availability, and setting up PostgREST.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/255-integer-overflow-user-friendly-permissions-dump-logical-replication-worker-config/
2023-03-1212 min
Scaling PostgresInteger Overflow, User-Friendly Permissions, Dump & Logical Replication, Worker Config | Scaling Postgres 255In this episode of Scaling Postgres, we discuss how to detect & handle integer overflows, a wish for user-friendly permissions, using a dump to start logical replication and configuring background workers.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/255-integer-overflow-user-friendly-permissions-dump-logical-replication-worker-config/
2023-03-0517 min
Scaling PostgresPG Edge Cache, Postgres & OpenAI, citext to Collations, Compression Options | Scaling Postgres 254In this episode of Scaling Postgres, we discuss PG Edge Cache, using Postgres & OpenAI, migrating citext to case-insenstive collations and PG16 compression options.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com
2023-02-2613 min
Scaling PostgresUnlogged Tables, pg_stat_io, Type Constraints, Text Types | Scaling Postgres 253In this episode of Scaling Postgres, we discuss working with unlogged tables, the new pg_stat_io feature, handling complex type constraints and choosing the best text type.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com
2023-02-2016 min
Scaling PostgresPostgres Releases, Performance Secrets, Don't Do This, Filter vs. Case | Scaling Postgres 252In this episode of Scaling Postgres, we discuss new Postgres releases, performance secrets, things not to do and filter vs. case.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com
2023-02-1314 min
Scaling PostgresFilter Clause, Hypothetical Index, Non-Relational Data, Using TOAST | Scaling Postgres 251In this episode of Scaling Postgres, we discuss how to use the filter clause, create hypothetical indexes, store non-relational data and manage TOAST.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/251-filter-clause-hypothetical-index-non-relational-data-using-toast/
2023-02-0516 min
Scaling PostgresPerformance Issue, Survive Without Superuser, Reserved Connections, Partition Management | Scaling Postgres 250In this episode of Scaling Postgres, we discuss resolving a performance issue, how PG16 allows you to survive without a superuser, reserving connections and handling partition management.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/250-performance-issue-survive-without-superuser-reserved-connections-partition-management/
2023-01-3014 min
Scaling PostgresLocking Tables, Foreign Key Issue, Slow Decimals, Memoize & Joins | Scaling Postgres 249In this episode of Scaling Postgres, we discuss issues with locking tables, foreign keys and slow decimals. We also cover when joins use memoize.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/249-locking-tables-foreign-key-issue-slow-decimals-memoize-joins/
2023-01-2309 min
Scaling PostgresPagination Solutions, Return Modifications, Insert Deletions, How To JSON | Scaling Postgres 248In this episode of Scaling Postgres, we discuss different pagination solutions, how to return modifications, soft deletion alternatives and how to use JSON with PostgreSQL.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/248-pagination-solutions-return-modifications-insert-deletions-how-to-json/
2023-01-1617 min
Scaling PostgresGenerate Test Data, Faster Archiving, Date Statistics, Useless Indexes | Scaling Postgres 247In this episode of Scaling Postgres, we discuss how to generate test data, how WAL archiving is faster in PG15, how to set date statistics on a timestamp and how to avoid useless indexes.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/247-generate-test-data-faster-archiving-date-statistics-useless-indexes/
2023-01-1114 min
Scaling PostgresColumnar Tables, Advent of Code, PG 16 Features, Commit Times | Scaling Postgres 246In this episode of Scaling Postgres, we discuss columnar table storage, solving Advent of Code using Postgres, new features coming in Postgres 16 and when Postgres development happens.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/246-columnar-tables-advent-of-code-pg16-features-commit-times/
2022-12-1810 min
Scaling PostgresENUMs vs Check Constraints, Faceting With Roaring Bitmaps, Better Scaling, In DB Business Logic | Scaling Postgres 245In this episode of Scaling Postgres, we discuss ENUMs vs. check constraints, querying table facets with roaring bitmaps, a better way to handle scaling and whether you should store your business logic in Postgres.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/245-enums-vs-check-constraints-faceting-with-roaring-bitmaps-better-scaling-in-db-business-logic/
2022-12-1211 min
Scaling PostgresIndex Merge vs Composite, Transparent Column Encryption, Trusted Language Extensions | Scaling Postgres 244In this episode of Scaling Postgres, we discuss merging indexes vs. a composite index, implementing transparent column encryption, developing trusted language extensions, and reviewing the WAL archive module.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/244-index-merge-vs-composite-transparent-column-encryption-trusted-language-extensions-wal-archive-module/
2022-12-0414 min
Scaling PostgresIN vs ANY, Ghost Conditions, Percentage Calculations, Variadic Unnest | Scaling Postgres 243In this episode of Scaling Postgres, we discuss how PG15 helps reduce replication lag, how to get the parameters used in prepared statements, PostGIS Day and how to use multiple pgbouncers.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/243-in-vs-any-ghost-conditions-percentage-calculations-variadic-unnest/
2022-11-2710 min
Scaling PostgresReduce Replication Lag, Explain Parameterized Query, PostGIS Day, Multiple PgBouncers | Scaling Postgres 242In this episode of Scaling Postgres, we discuss how PG15 helps reduce replication lag, how to get the parameters used in prepared statements, PostGIS Day and how to use multiple pgbouncers.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/242-reduce-replication-lag-explain-parameterized-query-postgis-day-multiple-pgbouncers/
2022-11-2111 min
Scaling PostgresPostgres 15.1, Postres 10 Retrospective, Reducing Replication Lag, Listen & Notify | Scaling Postgres 241In this episode of Scaling Postgres, we discuss the release of Postgres 15.1, a Postgres 10 retrospective, how to reduce replication lag and using listen & notify.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/241-postgres-15.1-postgres-10-retrospective-reducing-replication-lag-listen-notify/
2022-11-1317 min
Scaling PostgresForced Sequential Scans, Table Renaming, Terminology, PGSQL Phriday | Scaling Postgres 240In this episode of Scaling Postgres, we discuss how sequential scans can be forced, the best way to rename a table without downtime, different Postgres terminology and the PGSQL Phriday blogging event.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/240-forced-sequential-scans-table-renaming-terminology-pgsql-phriday/
2022-11-0619 min
Scaling PostgresShared Buffers, Compression Algorithm, Merge Command, Postgres Contributions | Scaling Postgres 239In this episode of Scaling Postgres, we discuss how to set shared buffers, the different WAL compression algorithm options, how to use the merge command and how to contribute to Postgres.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/239-shared-buffers-compression-algorithms-merge-command-postgres-contributions/
2022-10-3015 min
Scaling PostgresSlow Updates, Lateral Joins, Serial To Identity, PG 15 Changes | Scaling Postgres 238In this episode of Scaling Postgres, we discuss why and what to do when updates are slow, use cases for lateral joins, moving from serial to identity for auto-incrementing ids and changes to Postgres 15.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/238-slow-updates-lateral-joins-serial-to-identity-pg15-changes/
2022-10-2413 min
Scaling PostgresPostgres 15 Released, File Systems, Connection Pooling, Secure Connections | Scaling Postgres 237In this episode of Scaling Postgres, we discuss the release of Postgres 15, the performance of different file systems with Postgres, options for connection pooling and how to secure your connections.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/237-postgres-15-released-file-systems-connection-pooling-secure-connections/
2022-10-1618 min
Scaling PostgresPostgres 15 RC2, Shared Buffers, Secure Connections, PGSQL Phriday | Scaling Postgres 236In this episode of Scaling Postgres, we discuss the Postgres 15 RC2, optimizing shared buffers, how to secure your database connections and blog posts from PGSQL Phriday.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/236-postgres-15-rc2-shared-buffers-secure-connections-pgsql-phriday/
2022-10-1019 min
Scaling PostgresPostgres 15 RC1, ICU Collations, Listen & Notify, Understanding TOAST | Scaling Postgres 235In this episode of Scaling Postgres, we discuss the release of the Postgres 15 Release Candidate 1, new ICU collations features, how to use listen & notify and understanding TOAST.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/235-postgres-15-rc1-icu-collations-listen-notify-understanding-toast/
2022-10-0316 min
Scaling PostgresRust for Extensions, Timescale vs. Postgres, Uninterrupted Sharding, Data Flow | Scaling Postgres 234In this episode of Scaling Postgres, we discuss using rust for Postgres extensions, performance comparisons of TimescaleDB vs. Postgres, uninterrupted writes when sharding in Citus and the Postgres data flow.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/234-rust-for-extensions-timescale-vs-postgres-uninterrupted-sharding-data-flow/
2022-09-2616 min
Scaling PostgresUseful Features, Community Blogging, PG 15 Anticipation, Generic Plans | Scaling Postgres 233In this episode of Scaling Postgres, we discuss little known useful features, a monthly community blogging initiative, PG 15 Anticipation, and getting generic plans.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/233-useful-features-community-blogging-pg15-anticipation-generic-plans/
2022-09-1813 min
Scaling PostgresPG15 Beta 4, Primary Key Options, Sequence Limits, Configuration | Scaling Postgres 232In this episode of Scaling Postgres, we discuss the release of Postgres 15 Beta 4, different primary key options, sequence limits and how to examine your Postgres configuration.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/232-pg15-beta-4-primary-key-options-sequence-limits-configuration/
2022-09-1214 min
Scaling PostgresPG15 Public Schema, Kubernetes Experiences, Dump Manifests, PgBouncer Fork | Scaling Postgres 231In this episode of Scaling Postgres, we discuss the PG15 changes to public schema permissions, experiences with kubernetes for Postgres management, using dump manifests for restores and a fork of PgBouncer.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/231-pg15-public-schema-kubernetes-experiences-dump-manifests-pgbouncer-fork/
2022-09-0419 min
Scaling PostgresStats Collector Gone, Handling Latency, PG In The Browser, Future High Availability | Scaling Postgres 230In this episode of Scaling Postgres, we discuss how the stats collector disappears in PG15, steps to mitigate high latency connections, how to run Postgres in the browser and the future of high availability.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/230-stats-collector-gone-handling-latency-postgres-in-browser-future-high-availability/
2022-08-2812 min
Scaling PostgresPostgres Playground, PG14 Internals, DB Corruption, Anti-Join | Scaling Postgres 229In this episode of Scaling Postgres, we discuss a new Postgres playground, a book about PG14 internals, how to corrupt your database and using anti-joins.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/229-postgres-playground-pg14-internals-db-corruption-anti-join/
2022-08-2211 min
Scaling PostgresNew Postgres Releases, Privilege Escalation CVE, Chaos Testing, High Availability | Scaling Postgres 228In this episode of Scaling Postgres, we discuss new Postgres releases, a new privilege escalation CVE, chaos testing a high availability kubernetes cluster as well as addressing other H/A questions.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/228-new-postgres-releases-privilege-escalation-cve-chaos-testing-high-availability/
2022-08-1412 min
Scaling PostgresResearching Performance, Postgres Survey, pgAdmin Survey, Long Running Queries | Scaling Postgres 227In this episode of Scaling Postgres, we discuss PG14's new SQL function In this episode of Scaling Postgres, we discuss research into a performance puzzle, results from a Postgres and pgAdmin survey as well as the impacts of long running queries on Aurora and Postgres.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/227-researching-performance-postgres-survey-pgadmin-survey-long-running-queries/
2022-08-0708 min
Scaling PostgresSQL Functions, Explain Analyze Buffers, Debug Autovacuum, RLS Multi-Tenancy | Scaling Postgres 226In this episode of Scaling Postgres, we discuss PG14's new SQL function syntax, including buffers when doing explain analyze, how to debug autovacuum and using row-level security to handle multi-tenancy.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/226-sql-functions-explain-analyze-buffers-debug-autovacuum-rls-multi-tenancy/
2022-07-3116 min
Scaling PostgresPSQL GEXEC, Delete Duplicates, Postgres Podcast, Puny to Powerful | Scaling Postgres 225In this episode of Scaling Postgres, we discuss /gexec available in psql, how to delete duplicates using a window function, a new Postgres podcast and a performance talk about going from puny to powerful.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/225-psql-gexec-delete-duplicates-postgres-podcast-puny-powerful/
2022-07-2510 min
Scaling PostgresColumn Performance, BRIN Win, Unique and Null, Parallel Distinct | Scaling Postgres 224In this episode of Scaling Postgres, we discuss how too many columns in a table can affect performance, at what point BRIN indexes win over btree, and Postgres 15 supporting unique nulls and parallel distinct queries.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/224-column-performance-brin-win-unique-null-parallel-distinct/
2022-07-1813 min
Scaling PostgresDatabase Decomposition, Fast Text Search, Understanding pg_stat_activity, Window Functions | Scaling Postgres 223In this episode of Scaling Postgres, we discuss the process of decomposing your database, how to search text in Postgres quickly, how to understand the output of pg_stat_activity and how to use window functions to solve a use case.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/223-database-decomposition-fast-text-search-understanding-pg_stat_activity-window-functions/
2022-07-1014 min
Scaling PostgresPostgres 15 Beta 2, Concerning Locks, Vacuum Tuning, Transaction Anomalies | Scaling Postgres 222In this episode of Scaling Postgres, we discuss psql shortcuts, how to debug deadlocks, how to find & stop queries and how to understand and use SCRAM authentication.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/222-postgres-15-beta-2-concerning-locks-vacuum-tuning-transaction-anomalies/
2022-07-0417 min
Scaling Postgrespsql Shortcuts, Debugging Deadlocks, Find & Stop Queries, Using SCRAM | Scaling Postgres 221In this episode of Scaling Postgres, we discuss psql shortcuts, how to debug deadlocks, how to find & stop queries and how to understand and use SCRAM authentication.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/221-psql-shortcuts-debugging-deadlocks-find-and-stop-queries-using-scram/
2022-06-2717 min
Scaling PostgresPG 14.4 Release, Subscription Skip, Using Schemas, Open Source Citus | Scaling Postgres 220In this episode of Scaling Postgres, we discuss a PG 14.4 release, how to skip transactions with logical replication, how to use schemas and Citus going fully open source.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/220-pg-14.4-release-subscription-skip-using-schemas-open-source-citus/
2022-06-1918 min
Scaling PostgresOut-Of-Cycle Release, Should You Upgrade, Postgres Survey, Automatic Indexing | Scaling Postgres 219In this episode of Scaling Postgres, we discuss a Postgres 14 out-of-cycle release next week, whether you should upgrade, the state of Postgres survey and a tool for automatic indexing.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/219-out-of-cycle-release-should-you-upgrade-state-of-postgres-survey-automatic-indexing/
2022-06-1312 min
Scaling PostgresPG14 Index Bug, View Permissions, Logical Replication Conflicts, AlloyDB Under the Hood | Scaling Postgres 218In this episode of Scaling Postgres, we discuss a severe bug with index creation in Postgres 14, view permissions options, dealing with logical replication conflicts and looking under the hood of AlloyDB.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/214-pg14-index-bug-view-permissions-logical-replication-conflicts-alloydb-under-the-hood/
2022-06-0517 min
Scaling PostgresSchema Change Mistakes, Canceling Statements, pg_rman, Pedantry Removal | Scaling Postgres 217In this episode of Scaling Postgres, we discuss mistakes you can make when doing schema changes, how best to cancel statements, looking into pg_rman, and looking at a pedantry removal.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/217-schema-change-mistakes-canceling-statements-pg_rman-pedantry-removal/
2022-05-3016 min
Scaling PostgresPG 15 Beta 1 Release, Query Breakdown, Sort Performance, Prepared vs. Partitioned | Scaling Postgres 216In this episode of Scaling Postgres, we discuss the Beta 1 release of Postgres 15, optimizing a query by breaking it down, improvements to sort performance and prepared statements for partitioned tables.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/216-pg15-beta1-release-query-breakdown-sort-performance-prepared-vs-partitioned/
2022-05-2213 min
Scaling PostgresNew Releases, AlloyDB, Time Zones, Connecting to Postgres | Scaling Postgres 215In this episode of Scaling Postgres, we discuss parallel server-side backup compression, IO in Postgres, parquet files and the new pg_stat_monitor extension.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/215-new-releases-alloydb-time-zones-connecting-to-postgres/
2022-05-1617 min
Scaling PostgresBackup Compression, Postgres IO, Parquet Files, pg_stat_monitor | Scaling Postgres 214In this episode of Scaling Postgres, we discuss parallel server-side backup compression, IO in Postgres, parquet files and the new pg_stat_monitor extension.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/214-backup-compression-postgres-io-parquet-files-pg_stat_monitor/
2022-05-0919 min
Scaling PostgresPlanner Optimization, Fish to Elephants, Large Databases, Spatial Data | Scaling Postgres 213In this episode of Scaling Postgres, we discuss ways you can optimize the planner, becoming part of the Postgres Community, considerations for large databases and mapping three different types of spatial data.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/213-planner-optimization-fish-to-elephants-large-databases-spatial-data/
2022-05-0115 min
Scaling PostgresSlow Queries, 4TB Upgrade, Postgres on ZFS, Storage Stampede | Scaling Postgres 212In this episode of Scaling Postgres, we discuss dealing with slow queries, upgrading a 4TB database, running Postgres on ZFS and handling a storage stampede.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/212-slow-queries-4tb-upgrade-postgres-on-zfs-storage-stampede/
2022-04-2421 min
Scaling PostgresMultiranges, Missing Metrics, Newbie PostGIS, Conference Videos | Scaling Postgres 211In this episode of Scaling Postgres, we discuss working with multiranges, missing Postgres metrics, PostGIS for newbies and videos from CitusCon.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/211-mutiranges-missing-metrics-newbie-postgis-conference-videos/
2022-04-1711 min
Scaling PostgresDate Time Bins, Search Every Field, JSON_TABLE, Picking Primary | Scaling Postgres 210In this episode of Scaling Postgres, we discuss how to bin date times, search every field of a table, use JSON_TABLE and methods for a client to pick the primary database.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/210-date-time-bins-search-every-field-json_table-picking-primary/
2022-04-1109 min
Scaling PostgresTidy Vacuum, Dropping Roles, Merge Command, PgBouncer Tutorial | Scaling Postgres 209In this episode of Scaling Postgres, we discuss how to optimize vacuum, how to drop roles, the new merge command in PG15 and a pgbouncer tutorial.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/209-tidy-vacuum-dropping-roles-merge-command-pgbouncer-tutorial/
2022-04-0314 min
Scaling Postgrespgbouncer Released, Query Parameter Types, Lateral Joins, Security Invoker Views | Scaling Postgres 208In this episode of Scaling Postgres, we discuss a new version of pgbouncer, query parameter types, a performance improvement from a lateral join and security invoker views.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/208-pgbouncer-released-query-parameter-types-lateral-joins-security-invoker-views/
2022-03-2712 min
Scaling PostgresAutovacuum Configuration, Duplicate Key Violations, Pipelining, Tuning max_wal_size | Scaling Postgres 207In this episode of Scaling Postgres, we discuss how best to configure autovacuum, the dangers of duplicate key violations, how to set up pipelining, and how to tune max_wal_size.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/207-autovacuum-configuration-dupliate-key-violations-pipelining-tuning-max_wal_size/
2022-03-2017 min
Scaling Postgres100x Optimizations, Auditing, Document Schema Designs, Checksums | Scaling Postgres 206In this episode of Scaling Postgres, we discuss 100x optimizations, how to audit table activity, designing schemas and how to set up table checksums.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/206-100x-optimizations-auditing-document-schema-designs-checksums/
2022-03-1317 min
Scaling PostgresIndexing With tsearch, Tuples Not Yet Removable, Wicked Problems, Pattern Matching | Scaling Postgres 205In this episode of Scaling Postgres, we discuss the best ways to index with tsearch, what to check if tuples are not yet removable, wicked problems with Postgres and different pattern matching techniques.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/205-indexing-with-tsearch-tuples-not-yet-removable-wicked-problems-pattern-matching/
2022-03-0709 min
Scaling PostgresOptimizing Trigram Search, Replication Review, Logical Improvements, Timescale Investment | Scaling Postgres 204In this episode of Scaling Postgres, we discuss optimizing trigram searches, a review of Postgres replication, improvements to logical replication and a significant Timescale investment.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/204-optimizing-trigram-search-replication-review-logical-improvements-timescale-investment/
2022-02-2818 min
Scaling PostgresSaving Space, Working with TOAST, Protecting Data, High CPU Utilization | Scaling Postgres 203In this episode of Scaling Postgres, we discuss the new releases of Postgres, a hairy upgrade incident, why slowing down can make you go faster and using loadable modules for WAL archiving.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/203-saving-space-working-with-toast-protecting-data-high-cpu-utilization/
2022-02-2012 min
Scaling PostgresNew Postgres Releases, A Hairy Incident, Slow Down To Go Faster, Loadable Module Archiving | Scaling Postgres 202In this episode of Scaling Postgres, we discuss the new releases of Postgres, a hairy upgrade incident, why slowing down can make you go faster and using loadable modules for WAL archiving.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/202-new-postgres-releases-hairy-incident-slow-down-to-go-faster-loadable-module-archiving/
2022-02-1412 min
Scaling PostgresJSONB Performance, Bidirectional Replication, Most Recent Record, PG14 JSON | Scaling Postgres 201In this episode of Scaling Postgres, we discuss JSONB performance, bidirectional replication, getting the most recent record and using JSON in Postgres 14.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/201-jsonb-performance-bidirectional-replication-most-recent-record-pg14-json/
2022-02-0715 min
Scaling Postgres5 Minutes of Postgres, Unnest, SCRAM, Multi-master Review | Scaling Postgres 200In this episode of Scaling Postgres, we discuss the new series 5 minutes of Postgres, using unnest, switching to SCRAM authentication and reviewing multi-master solutions.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/200-5-minute-postgres-unnest-scram-multi-master-review/
2022-01-3112 min
Scaling PostgresShaped Sample Data, Version Changes, Missed Bottlenecks, Indexes for Newbies | Scaling Postgres 199In 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/
2022-01-2412 min
Scaling PostgresMonitoring Progress, More SQL, Replication Slot Failover, Postgres Contributors | Scaling Postgres 198In 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/
2022-01-1614 min
Scaling PostgresExplain Analyze Buffers, Healthier Postgres, 2021 Review, High Availability Aspirations | Scaling Postgres 197In 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/
2022-01-1014 min
Scaling PostgresEasy Recursive CTE, Zheap Undo, High Availability, Loading Data | Scaling Postgres 196In 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/
2021-12-1917 min
Scaling PostgresAurora vs. Postgres, Surprising Transactions, Write-Only & Read-Only, Indexing Advice | Scaling Postgres 195In 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/
2021-12-1318 min
Scaling PostgresGo Faster, GIN Indexes, Collation Stability, PG14 & Beyond | Scaling Postgres 194In 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/
2021-12-1016 min
Scaling PostgresEntity-Attribute-Value Design, JSON Subscripting, mysql-fdw Push-down, New Regex | Scaling Postgres 193In 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/
2021-11-2809 min
Scaling PostgresForeign Key Indexes, Graph Queries, Linux Huge Pages, Text Column Size | Scaling Postgres 192In 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/
2021-11-2312 min
Scaling PostgresMan-In-The-Middle, pg_auto_failover, Lesser Known Features, LZ4 Compression | Scaling Postgres 191In 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/
2021-11-1514 min
Scaling PostgresHello Babelfish, Planner Deconstruction, Exist & Not Exist, Fun With SQL | Scaling Postgres 190In 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/
2021-11-0812 min
Scaling PostgresIndex Downsides, TCP Keep Alive, Development with Postgres, Learning PL/pgSQL | Scaling Postgres 189In 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/
2021-11-0115 min
Scaling PostgresAutomatic Indexing, Function Pipelines, With Hold Cursors, Query Scans | Scaling Postgres 188In 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/
2021-10-2515 min
Scaling PostgresSharding, Federation, Linux HugePages, Performance Tuning | Scaling Postgres 187In 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/
2021-10-1815 min
Scaling PostgresSelect For Update, PGx Framework, Cool Additions, Full-Text Search | Scaling Postgres 186In 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/
2021-10-1008 min
Scaling PostgresPostgres 14 Released, Using JSON, Not Using Indexes, Sequence Gaps | Scaling Postgres 185In 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/
2021-10-0421 min
Scaling PostgresPostgres 14 RC1, Little Things, Index Advisor, Million Inserts | Scaling Postgres 184In 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/
2021-09-2612 min
Scaling PostgresBroken Indexes, Trademark Issues, Percentile vs. Average, Logical Improvements | Scaling Postgres 183In 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/
2021-09-2014 min
Scaling PostgresBoundless Text, Revoked Permissions, Index Bloat, Hardware Performance | Scaling Postgres 182In 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/
2021-09-1213 min
Scaling PostgresConnection Scaling, Cached Sequences, Message Queuing, Harmful Subtransactions | Scaling Postgres 181In 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/
2021-09-0621 min