Scaling Postgres Episode 167 Interpreting Explain Analyze | Bulk Loading Data | Limiting Update & Delete | pg_buffercache

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.

Content Discussed

• How to interpret PostgreSQL EXPLAIN ANALYZE output
• PostgreSQL: Bulk loading huge amounts of data
• Simulating UPDATE or DELETE with LIMIT in Postgres: CTEs to The Rescue!
• Memory inspection thru pg_buffercache
• New Features in PostgreSQL 14: Bulk Inserts for Foreign Data Wrappers
• Enhancements to the target_session_attrs database connection parameter in PostgreSQL 14
• Tracking the refresh Performance of Materialized Views with mv_stat in PostgreSQL
• Speeding Up PostgreSQL Recovery with pgBackRest
• Using Postgres Row-Level Security in Ruby on Rails
• Postgres 14 highlight - Fun with Hashes
• Georgios Kokolatos

YouTube Video