Postgres FM

home_filledExplore shows

listSubscriptions

playlist_addQueue

addAdd by RSS Feed

Settings

Help Content policies Publisher guidelines

Send feedback

open_in_newGet the Android app open_in_newGet the iOS app

Privacy · Terms

Postgres FM

Nikolay Samokhvalov and Michael Christofides

Subscribe

A weekly podcast about all things PostgreSQL

Postgres FM

Available episodes



Newest first

Oldest first

Default configuration

Nikolay and Michael discuss the default config — some tools and principles you can use to customise it, as well as several parameters you probably always want to change. Here are links to a few things we mentioned: * shared_buffers * Andres Freund tweets about shared_buffers * PGTune Leopard * Cybertec Configurator * pg_stat_statements * JIT configuration * postgresqlco.nf * annotated.conf * OtterTune * work_mem * random_page_cost * max_connections * What to log * max_wal_size * WAL and checkpoint tuning episode * effective_cache_size * Intro to Performance Tuning and Optimization (EDB guide) * max_parallel_workers_per_gather ------------------------ What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov / @michristofides / @PostgresFM, or by commenting on our Google doc. If you would like to share this episode, here's a good link (and thank you!) Postgres FM is brought to you by: * Nikolay Samokhvalov, founder of Postgres.ai * Michael Christofides, founder of pgMustard With special thanks to: * Jessie Draws for the amazing artwork

Infra cost optimization

Here are links to a few things we mentioned: * The Cost of Cloud, a Trillion Dollar Paradox (blog post from Andreessen Horowitz) * OVH * Hetzner * postgresql_cluster * Why we're leaving the cloud (blog post by DHH from Basecamp) * Managed services vs. DIY episode * ec2instances.info * Vantage * Postgres TV episode with Everett Berry from Vantage * Migrating to Aurora: easy except the bill (blog post by Kimberly Nicholls from Gridium) * Database Lab Engine * Postgres.ai consulting * Netdata * sysbench * fio * Query macro analysis episode * Top queries by buffers (Gist from Michael) ------------------------ What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov / @michristofides / @PostgresFM, or by commenting on our Google doc. If you would like to share this episode, here's a good link (and thank you!) Postgres FM is brought to you by: * Nikolay Samokhvalov, founder of Postgres.ai * Michael Christofides, founder of pgMustard With special thanks to: * Jessie Draws for the amazing artwork

Here are links to a few things we mentioned: * Crunchy Data PostgreSQL Security Technical Implementation Guide (STIG) * pgAudit (site) * pgAudit (repo) * noset (extension) * Splunk * Kibana * Timescale * CREATE TRIGGER docs * Transition table triggers (blog post by David Fetter) * Table Audit (blog post by Lorenzo Alberton) * Row change auditing options (blog post by CYBERTEC) * Hydra founders interview (on Postgres TV) * max_slot_wal_keep_size * eBPF * Building a perf-like tool for PostgreSQL (talk by Ronan Dunklau) * Party tricks for PostgreSQL: perf, ftrace and bpftrace (talk by Dmitry Dolgov) ------------------------ What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov / @michristofides / @PostgresFM, or by commenting on our Google doc. If you would like to share this episode, here's a good link (and thank you!) Postgres FM is brought to you by: * Nikolay Samokhvalov, founder of Postgres.ai * Michael Christofides, founder of pgMustard With special thanks to: * Jessie Draws for the amazing artwork

Copying a database

Here are links to a few things we mentioned: * pg_dump * pg_restore * pgcopydb (tool by Dimitri Fontaine) * pg_dump and external snapshots (blog post by Michael Paquier) * Systems Performance (book by Brendan Gregg) * Performance troubleshooting methodologies (two part talk by Brendan Gregg) * pg_basebackup * wal-g * pgBackRest * Database Lab Engine * Database branching episode ------------------------ What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov / @michristofides / @PostgresFM, or by commenting on our Google doc. If you would like to share this episode, here's a good link (and thank you!) Postgres FM is brought to you by: * Nikolay Samokhvalov, founder of Postgres.ai * Michael Christofides, founder of pgMustard With special thanks to: * Jessie Draws for the amazing artwork

Transaction ID wraparound

Here are links to a few things we mentioned: * The Internals of PostgreSQL chapter 5 (book by Hironobu SUZUKI) * PostgreSQL 14 internals chapter 7 (book by Egor Rogov) * Transaction ID Wraparound (blog post from Sentry) * What We Learned from the Recent Mandrill Outage (blog post from Mailchimp) * How to simulate transaction ID wraparound (blog post by Prashant Dixit) * Add 64-bit XIDs into PostgreSQL 16 (commitfest entry) * Partitioning (docs) * Consider using VACUUM’s INDEX_CLEANUP option (tweet by Peter Geoghan) * Add wraparound failsafe to VACUUM (commit) * Do you vacuum everyday? (talk by Hannu Krosing) * Multixacts wraparound monitoring (mailing list thread) * Subtransactions Considered Harmful (blog post by Nikolay) * Buffer management in PostgreSQL (talk by Alexander Korotkov) * OrioleDB * pageinspect * pg_hexedit * pg_visibility * Visibility Map (docs) ------------------------ What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov / @michristofides / @PostgresFM, or by commenting on our Google doc. If you would like to share this episode, here's a good link (and thank you!) Postgres FM is brought to you by: * Nikolay Samokhvalov, founder of Postgres.ai * Michael Christofides, founder of pgMustard With special thanks to: * Jessie Draws for the amazing artwork

Postgres year in review 2022

Here are links to a few things we mentioned: 1. Startups building momentum * Aiven raised $210m * Timescale raised $110m * Hasura raised $100m * Supabase raised $80m * Neon raised $30m * Hydra * OrioleDB 2. Educational resources * Postgres FM started 👋 * Postgres TV became more active (including topic playlists) * Tobias Petry tips on Twitter and SQL for Devs * Hussein Nasser YouTube channel (backend engineering) * Postgres Weekly (newsletter) 3. Sharding progress * Citus goes fully open source * SPQR * pgcat * Sharding Postgres at Notion (blog post) * PlanetScale (MySQL) 4. Database branching is coming * Database Lab Engine * Neon branching * OrioleDB branching * Crunchy Bridge * Database branching episode 5. Postgres is everywhere * All cloud providers * AlloyDB announced * Kubernetes operators (comparison blog post) ------------------------ What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov / @michristofides / @PostgresFM, or by commenting on our Google doc. If you would like to share this episode, here's a good link (and thank you!) Postgres FM is brought to you by: * Nikolay Samokhvalov, founder of Postgres.ai * Michael Christofides, founder of pgMustard With special thanks to: * Jessie Draws for the amazing artwork

Here are links to a few things we mentioned: * ANALYZE (docs) * Autovacuum config (docs) * Statistics used by the planner (docs) * CREATE STATISTICS (docs) * Row count estimates (pgMustard blog post) * pg_hint_plan * Optimizer methodology (talk by Robert Haas) * Tomáš Vondra on statistics and hints (an excellent interview we forgot to mention, sorry!) ------------------------ What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov / @michristofides / @PostgresFM, or by commenting on our Google doc. If you would like to share this episode, here's a good link (and thank you!) Postgres FM is brought to you by: * Nikolay Samokhvalov, founder of Postgres.ai * Michael Christofides, founder of pgMustard With special thanks to: * Jessie Draws for the amazing artwork

Here are links to a few things we mentioned: * Replication (docs) * 9.0 release notes (including built-in replication) * Slony * Londiste * pg_is_in_recovery (pgPedia page) * Patroni * Multiple Databases with Active Record * hot_standby_feedback (docs) * max_standby_archive_delay or max_standby_streaming_delay (for WAL-shipping and WAL-streaming respectively) * synchronous_commit * Synchronous replicas * Database Lab Engine * Neon Branching * Past, Present, and Future of Logical Replication (Postgres TV with Amit Kapila) * Failover of logical replication slots in Patroni (Postgres TV with Alexander Kukushkin) * PostgreSQL Subtransactions Considered Harmful (blog post by Nikolay) * Why we spent the last month eliminating PostgreSQL subtransactions (blog post by GitLab) * Fivetran ------------------------ What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov / @michristofides / @PostgresFM, or by commenting on our Google doc. If you would like to share this episode, here's a good link (and thank you!) Postgres FM is brought to you by: * Nikolay Samokhvalov, founder of Postgres.ai * Michael Christofides, founder of pgMustard With special thanks to: * Jessie Draws for the amazing artwork

Here are links to a few things we mentioned: * Date/Time Types (docs) * Don’t use timestamp without time zone (wiki) * Date/Time functions and operators (docs) * Postgres AT TIME ZONE explained (blog post by Bruce Momjian) * Our episode on BRIN indexes * RUM indexes * allballs (mailing list thread) ------------------------ What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov / @michristofides / @PostgresFM, or by commenting on our Google doc. If you would like to share this episode, here's a good link (and thank you!) Postgres FM is brought to you by: * Nikolay Samokhvalov, founder of Postgres.ai * Michael Christofides, founder of pgMustard With special thanks to: * Jessie Draws for the amazing artwork

Here are links to a few things we mentioned: * PostgREST documentation * Supabase * No offset (blog post by Markus Winand) * JSON functions and operators (PostgreSQL docs) * Stored procedures (a previous Postgres FM episode) * PostGraphile * Hasura * Parse, Inc. * Firebase * PostgresML * PgQ ------------------------ What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov / @michristofides / @PostgresFM, or by commenting on our Google doc. If you would like to share this episode, here's a good link (and thank you!) Postgres FM is brought to you by: * Nikolay Samokhvalov, founder of Postgres.ai * Michael Christofides, founder of pgMustard With special thanks to: * Jessie Draws for the amazing artwork

Materialized views

Apologies, Michael's audio is not great in this, we'll hopefully be back to normal next week! Here are links to a few things we mentioned: * Materialized views (docs) * Refresh materialized view (docs) * Timescale blog post * PlanetScale Boost (content warning: MySQL) * Incremental Materialized Views with pg_ivm (video by Lukas Fittl) * Articles on how to do your own incremental updates(?) * Materialize (company) * Materialize talk * Incremental View Maintenance (Postgres wiki) * Implementing Incremental View Maintenance (mailing list thread) ------------------------ What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov / @michristofides / @PostgresFM, or by commenting on our Google doc. If you would like to share this episode, here's a good link (and thank you!) Postgres FM is brought to you by: * Nikolay Samokhvalov, founder of Postgres.ai * Michael Christofides, founder of pgMustard With spe…

Here are links to a few things we mentioned: * Heap-only tuple updates (docs) * README file (source code) * Heap Only Tuple chapter (Internals of PostgreSQL by Hironobu SUZUKI) * How partial, covering, and multicolumn indexes may slow down UPDATEs (blog post by Nikolay) * Why Uber switched from Postgres to MySQL (blog post) * Fighting write amplification with HOT updates (Adyen blog post) * HOT Updates vs Bottom-Up Index Deletion (video by Lukas Fittl from pganalyze) * Reduced Bloat with Bottom-Up Deletion (blog post by Hamid Akthar from Percona) * What is fillfactor and how does it affect performance? (blog post by Kaarel Moppel from Cybertec) ------------------------ What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov / @michristofides / @PostgresFM, or by commenting on our Google doc. If you would like to share this episode, here's a good link (and thank you!) Postgres FM is brought to you by:…

Database branching

Here are links to a few things we mentioned: * Database Lab Engine * Overview of Aurora cloning * PlanetScale branching * Common DB schema change mistakes (blog post by Nikolay) * Supabase vision * Neon branching * Shift-left testing ------------------------ What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov / @michristofides / @PostgresFM, or by commenting on our Google doc. If you would like to share this episode, here's a good link (and thank you!) Postgres FM is brought to you by: * Nikolay Samokhvalov, founder of Postgres.ai * Michael Christofides, founder of pgMustard With special thanks to: * Jessie Draws for the amazing artwork

Version control for databases

Here are links to a few things we mentioned: * A brief history of Version Control Systems (blog post by Mehran Hajirajabi) * Redgate Source Control for Oracle (and SQL Server) * Flyway * Sqitch * Liquibase * pgAdmin Schema Diff * Migra * PostgresCompare * Schema based versioning and deployment (blog post by Valentine Gogichashvili) * Change management tools and techniques (PostgreSQL Wiki) * GitLab migration_helpers.rb * Database schema changes without downtime (blog post by James Coleman from Braintree/PayPal) * Zero-downtime Postgres schema migrations need lock_timeout and retries (blog post by Nikolay) ------------------------ What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov / @michristofides / @PostgresFM, or by commenting on our Google doc. If you would like to share this episode, here's a good link (and thank you!) Postgres FM is brought to you by: * Nikolay Samokhvalov, foun…

Contributing to Postgres

Here are links to a few things we mentioned: * PostgreSQL 14 coin (upside down!) * Intro to Planner Hacking (talk by Melanie Plageman) * Demystifying contributing to PostgreSQL (talk by Lætitia Avrot) * How to become a PostgreSQL contributor (blog post by Aleksander Alekseev) * Compile and install from source code (PostgreSQL Wiki) * PostgreSQL mailing lists * GitHub PostgreSQL mirror * GitLab PostgreSQL mirror * Commitfests * So, you want to be a developer? (PostgreSQL Wiki) * Resolving the search engine issue (mailing list thread) * Planet PostgreSQL * pg_stat_monitor (extension by Percona) * ZomboDB * pgx (framework for developing extensions) * Awesome Postgres * Depesz blog ------------------------ What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov / @michristofides / @PostgresFM, or by commenting on our Google doc. If you would like to share this episode, here's a good link (a…

Stored procedures

Here are links to a few things we mentioned: * Extending SQL * PostgREST * PL/pgSQL * EdgeDB * pgTAP * Sqitch * Flyway * Liquibase * client_min_messages * log_min_messages * RAISE DEBUG * Simplify: move code into database functions (blog post by Derek Sivers) * PL/sh * Supabase * auto_explain.log_nested_statements * Hasura ------------------------ What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov / @michristofides / @PostgresFM, or by commenting on our Google doc. If you would like to share this episode, here's a good link (and thank you!) Postgres FM is brought to you by: * Nikolay Samokhvalov, founder of Postgres.ai * Michael Christofides, founder of pgMustard With special thanks to: * Jessie Draws for the amazing artwork

Here are links to a few things we mentioned: * PostgreSQL 15 release notes * Speeding up sort performance in Postgres 15 (blog post by David Rowley) * Past, Present, and Future of Logical Replication (talk by Amit Kapila) * Postgres 15 improves UNIQUE and NULL (blog post by Ryan Lambert) * Do you vacuum everyday? (talk by Hannu Krosing) * Why upgrade PostgreSQL? (by depesz) What did you like or not like? What should we discuss next time? Let us know by tweeting us on @PostgresFM or by commenting on our topic ideas Google doc. If you would like to share this episode, here's a good link (and thank you!) ------------------------ Postgres FM is brought to you by: * Nikolay Samokhvalov, founder of Postgres.ai * Michael Christofides, founder of pgMustard With special thanks to: * Jessie Draws for the amazing artwork

102 Query optimization

Here are links to a few things we mentioned: * pg_plan_advsr * How partial, covering, and multicolumn indexes may slow down UPDATEs (blog post by Nikolay) * Why Uber Switched from Postgres to MySQL (blog post) * pganalyze index advisor * Nancy bot (project is not active) * pgreplay * pgreplay go * Real Application Testing on YugabyteDB with pgreplay (blog post by Franck Pachot) * pg_query * Database Lab thin clones * Migrating to Aurora: easy except the bill (blog post by Kimberley Nicholls) ------------------------ What did you like or not like? What should we discuss next time? Let us know by tweeting us on @PostgresFM or by commenting on our topic ideas Google doc. If you would like to share this episode, here's a good link (and thank you!) Postgres FM is brought to you by: * Nikolay Samokhvalov, founder of Postgres.ai * Michael Christofides, founder of pgMustard With special thanks to: * Jessie Draws for the amazing artwork

Why is Postgres popular?

This episode was badly affected by internet issues. Hopefully the edit came out ok, but the quality should be back to a better level from next week. Here are links to a few things we mentioned: * Monthly blog event, PGSQL Phriday (blog post from Ryan Booz) * Who or what made Postgres cool? (tweet from Kenneth Cassel) * PostGIS * Acquisition of Sun by Oracle * DB-Engines trend * Hacker News hiring trends * Supabase on GitHub (nearly 40k stars) * How I Built This (podcast) ------------------------ What did you like or not like? What should we discuss next time? Let us know by tweeting us on @PostgresFM or by commenting on our topic ideas Google doc. If you would like to share this episode, here's a good link (and thank you!) Postgres FM is brought to you by: * Nikolay Samokhvalov, founder of Postgres.ai * Michael Christofides, founder of pgMustard With special thanks to: * Jessie Draws for the amazing artwork

Index maintenance

Important correction from this episode: amcheck promises no false positives, not no false negatives, sorry! Here are links to a few things we mentioned: * pgstattuple * pg_repack * postgres-checkup * Workload Analysis for GitLab.com * Bloat Analysis (also from GitLab) * Bloat, pg_repack, and deferred constraints (blog post by Miro) * amcheck * Peter Geoghegan interview (on Postgres TV) ------------------------ What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov and @michristofides or by commenting on our topic ideas Google doc. If you would like to share this episode, here's a good link (and thank you!) Postgres FM is brought to you by: * Nikolay Samokhvalov, founder of Postgres.ai * Michael Christofides, founder of pgMustard With special thanks to: * Jessie Draws for the amazing artwork

Query macro analysis intro

Here are links to a few things we mentioned: * pg_stat_statements * pgFouine * pgBadger * pg_query * pg_stat_activity * auto_explain * Can auto_explain (with timing) have low overhead? (blog post by Michael) * track_io_timing * pgbench * PgHero * pgCenter * pgwatch2 (Postgres AI edition) * pg_stat_kcache * PASH Viewer ------------------------ What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov and @michristofides or by commenting on our topic ideas Google doc. If you would like to share this episode, here's a good link (and thank you!) Postgres FM is brought to you by: * Nikolay Samokhvalov, founder of Postgres.ai * Michael Christofides, founder of pgMustard With special thanks to: * Jessie Draws for the amazing artwork

WAL and checkpoint tuning

Here are links to a few things we mentioned: * LSN (log sequence number) * On the impact of full-page writes (blog post by Tomas Vondra) * Deep dive on Aurora Postgres (talk by Grant McAlister) * Netdata monitoring * PostgresqlCO.NF * pgPedia ------------------------ What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov and @michristofides or by commenting on our Google doc. If you would like to share this episode, here's a good link (and thank you!) Postgres FM is brought to you by: * Nikolay Samokhvalov, founder of Postgres.ai * Michael Christofides, founder of pgMustard With special thanks to: * Jessie Draws for the amazing artwork

Intro to query optimization

Here are links to a few things we mentioned: * Using EXPLAIN (PostgreSQL documentation) * explain.depesz.com * explain.dalibo.com * pgMustard * EverSQL * pganalyze * pg_stat_monitor (Extension by Percona) * Recent thread on hackers mailing list about plan_id in pg_stat_activity * auto_explain * EXPLAIN observer effect (Ongres blog post by Álvaro Hernández) * auto_explain overhead (blog post by Michael) * pg_test_timing * Database Lab Engine (for thin clones) * Our previous episode on BUFFERS * EXPLAIN Explained (talk by Josh Berkus) * A beginner's guide to EXPLAIN (talk by Michael) * A deeper dive into EXPLAIN (talk by Michael) * EXPLAIN glossary (pgMustard docs) * Topic suggestions document ------------------------ What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov and @michristofides or by commenting on our Google doc. If you would like to share this episode, here's a good…

How to become a DBA

And few things we mentioned: * Topic request on Reddit — thanks HerbyHoover! * Haki Benita's blog * PostgreSQL documentation (table of contents) * Planet PostgreSQL (blog aggregator) * MVCC Unmasked (by Bruce Momjian) * The Internals of PostgreSQL (by Hironobu SUZUKI) * PostgreSQL 14 Internals — parts I and II (by Egor Rogov) * Cybertec blog * modern-sql.com (by Markus Winand) * use-the-index-luke.com (by Markus Winand) * The Art of PostgreSQL (by Dimitri Fontaine) * explain.depesz.com * explain.dalibo.com ------------------------ What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov and @michristofides If you would like to share this episode, here's a good link (and thank you!) Postgres FM is brought to you by: * Nikolay Samokhvalov, founder of Postgres.ai * Michael Christofides, founder of pgMustard With special thanks to: * Jessie Draws for the amazing artwork

Monitoring checklist

Monitoring checklist (dashboard 1): * TPS and (optional but also desired) QPS * Latency (query duration) — at least average. Better: histogram, percentiles * Connections (sessions) — stacked graph of session counts by state (first of all: active and idle-in-transaction; also interesting: idle, others) and how far the sum is from max_connection (+pool size for PgBouncer). * Longest transactions (max transaction age or top-n transactions by age), excluding autovacuum activity * Commits vs rollbacks — how many transactions are rolled back * Transactions left till transaction ID wraparound * Replication lags / bytes in replication slot / unused replication slots * Count of WALs waiting to be archived (archiving lag) * WAL generation rates * Locks and deadlocks * Basic query analysis graph (top-n by total_time or by mean_time?) * Basic wait event analysis (a.k.a. “active session analysis” or “performance insights”) And links to a few things we mention…

Here are links to a few things we mentioned: * Do you vacuum everyday? (talk by Hannu Krosing) * Autovacuum tuning (EDB guide) * When autovacuum does not vacuum (2ndQuadrant blog post by Tomas Vondra) * Autovacuum tuning basics (old 2ndQuadrant blog post) * Discussion with Anastasia Lubennikova (on RuPostgres, in Russian) * B-tree indexes (talk by Anastasia Lubennikova, in English) * Discussion with Peter Geoghegan (on Postgres TV) * pg_repack * pg_squeeze ------------------------ What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov and @michristofides If you would like to share this episode, here's a good link (and thank you!) Postgres FM is brought to you by: * Nikolay Samokhvalov, founder of Postgres.ai * Michael Christofides, founder of pgMustard With special thanks to: * Jessie Draws for the amazing artwork

NULLs: the good, the bad, the ugly, and the unknown

Here are links to a few things we mentioned: * Three-valued_logic (Wikipedia) * Postgres 15 improves UNIQUE and NULL (blog post by Ryan Lambert) * Practical SQL for Data Analysis — Interpolation (blog post by Haki Benita) * What is the deal with NULLs? (blog post by Jeff Davis) * NULL in SQL: Indicating the Absence of Data (Markus Winand on Modern SQL) * The Art of PostgreSQL (book by Dimitri Fontaine) ------------------------ What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov and @michristofides If you would like to share this episode, here's a good link (and thank you!) Postgres FM is brought to you by: * Nikolay Samokhvalov, founder of Postgres.ai * Michael Christofides, founder of pgMustard With special thanks to: * Jessie Draws for the amazing artwork

BUFFERS by default

Here are links to a few things we mentioned: * EXPLAIN parameters (PostgreSQL documentation) * EXPLAIN (ANALYZE) needs BUFFERS (blog post by Nikolay) * Using BUFFERS for query optimization (blog post by Michael) * H3 indexes on PostGIS data (blog post by Ryan Lambert) * Turning BUFFERS on by default (latest patch) * pgMustard * explain.depesz.com * explain.dalibo.com * Database Lab Engine ------------------------ What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov and @michristofides If you would like to share this episode, here's a good link (and thank you!) Postgres FM is brought to you by: * Nikolay Samokhvalov, founder of Postgres.ai * Michael Christofides, founder of pgMustard With special thanks to: * Jessie Draws for the amazing artwork

Here are links to the two main resources we mentioned: * Paul Ramsey's recent blog post on BRIN indexes * Tomas Vondra's slides on BRIN index improvements A few other things we mentioned: * B-tree Wikipedia page * pg_repack * pg_squeeze ------------------------ What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov and @michristofides If you would like to share this episode, here's a good link (and thank you!) Postgres FM is brought to you by: * Nikolay Samokhvalov, founder of Postgres.ai * Michael Christofides, founder of pgMustard With special thanks to: * Jessie Draws for the amazing artwork

Managed services vs. DIY

A well as discussing pros and cons, we mentioned a LOT of different providers and tools, and a few good articles/videos too. 😅 Here are links to most of them, roughly in the order they came up: * How Auto Trader migrated its on-prem databases to Cloud SQL * PostgreSQL Community Panel: Upgradability * Postgres TV Open Talks * PostgreSQL Conference Europe * Hannu Krosing — excellent vacuum talk * pg_docs_bot — browser extension for getting to the current docs * Amazon RDS for PostgreSQL * Google Cloud SQL for PostgreSQL * Heroku Postgres * Crunchy Bridge * Spilo: HA PostgreSQL Clusters with Docker * Aiven for PostgreSQL * AlloyDB for PostgreSQL * Neon * Yugabyte * ScaleGrid PostgreSQL Hosting * StackGres * Timescale * OrioleDB * Citus * Supabase * PlanetScale * pg_stat_kcache * pg_wait_sampling * EDB BigAnimal * Azure Database for PostgreSQL ------------------------ What did you like or not like? What should we discuss next t…

Slow queries and slow transactions

What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov and @michristofides If you would like to share this episode, here's a good link (and thank you!) Postgres FM is brought to you by: * Nikolay Samokhvalov, founder of Postgres.ai * Michael Christofides, founder of pgMustard With special thanks to: * Jessie Draws for the amazing artwork

Search

Clear search

Close search

Google apps

Main menu