Postgres Conference Orlando 2025
2025-03-18..2025-03-21
Orlando, United States
| title | author | length |
|---|---|---|
| Analytics in Postgres –A decade in the making | Zhou Sun | 21m |
Postgres gains columnar scans by embedding a vectorized engine rather than reimplementing one: pg_mooncake provides columnstore tables backed by DuckDB’s… | ||
| From Greenplum to Apache Cloudberry | Shine Zhang | 53m |
Session Title: From Greenplum to Apache Cloudberry
Speaker(s): Shine Zhang
Track: Variants and Cloud
Session Description
(Audio Only)
For those interested in… | ||
| PostgreSQL at Amazon | Jim Mlodgenski | 19m |
Amazon moves from Oracle to PostgreSQL at massive scale: migrated 7,500 Oracle databases and 75 PB of data into Postgres variants, drove Redshift (initially… | ||
| Rules of Indexing in PostgreSQL | Alan Zakrzewski | 37m |
Complete walkthrough of PostgreSQL index types with concrete numbers and demos: B‑Tree sort keys cut an example query from 84ms to ~66ms and NULLS FIRST saves… | ||
| Seamless Migration to Azure Database for PostgreSQL | Jean Joseph | 56m |
Step‑by‑step migration process with concrete tools: use Azure Database Migration Service for online minimal‑downtime moves or PG dump/pg_restore and… | ||
| Redgate Monitor and pgNow | Ryan Booz | 50m |
Covers two Redgate tools: pgNow, a free cross‑platform desktop preview that takes 10‑second snapshots of pg_stat_statements and pg_stat_activity to show… | ||
| End Of Life Is Not the End | Vivek Singh, Kiran Janarthan Singh | 51m |
Postgres major versions ship yearly and get five years of support so Postgres 13 has EOL this year; remaining on EOL risks no CVE patches, compliance failures… | ||
| Surviving & Thriving in Remote Work as a Neurodivergent Professional | Debra Cerda | 49m |
Remote work amplifies sensory overload, time blindness, and executive dysfunction and the practical fixes include designing a sensory‑friendly workspace (warm… | ||
| PostgreSQL Disaster Recovery Fundamentals | Rilwan Musa | 22m |
Claims that replication alone is not enough and a practical DR plan combines physical base backups, WAL archiving and tested restores; demonstrates using… | ||
| From Text to Meaning: pgvector Transforms PostgreSQL Search | Kiran J, Vivek S | 48m |
pgvector adds native vector storage, distance operators and indexes to PostgreSQL so you can run semantic search and recommendations without a separate vector… | ||
| How I Took My Open Source Business to a Fortune 500 Company | Michael Meskes | 24m |
A small open source services company gets acquisition interest after three months and averages half a dozen inquiries per year, then merges with a… | ||
| Leading a High-Performing Postgres Team: Culture of Excellence & Growth | Jose Pereira | 45m |
Combines concrete ops and leadership tactics: backup and recovery, security, solid data modeling, and high availability using Kubernetes, Ansible, reliable… | ||
| Streamlining Metadata Management with PostgreSQL and Apache Gravitino | Lisa Cao | 33m |
Centralized metadata layer that federates existing meta stores (including PostgreSQL via a JDBC connector) and enforces pushdown policies at the query engine… | ||
| Why Google Cloud is the Best Place for Your PostgreSQL Workload | Sanjay Mishra | 24m |
Google Cloud offers three concrete PostgreSQL paths: Cloud SQL as a mature managed Postgres used by 95% of top 100 customers, AlloyDB (storage disaggregated, a… | ||
| Advanced Indexing Techniques in PostgreSQL | Charly Batista | 53m |
Covers concrete index types (B‑Tree/B+ tree, hash = O(1), BRIN, GIN, GiST) and when each actually speeds queries; shows BRIN suits append‑only time‑series, GIN… | ||
| Moving from MSSQL to pgSQL – High Availability and Disaster Recovery | Rick Lowe | 50m |
Compares SQL Server patterns to concrete PostgreSQL equivalents and pitfalls: streaming replication provides synchronous or asynchronous replicas like… | ||
| Ensuring High Availability in Self-Managed PostgreSQL with Patroni | Arnab Saha | 41m |
Three demos show a concrete path from manual backups to automated failover: a single-node backup using wal-g to S3, a three-node streaming setup built with… | ||
| Replacing Oracle Features in PostgreSQL: HA, Functions & Extensibility | Shayon Sanyal | 01h 09m |
Shows concrete replacements and proven results: 20+ Oracle→Postgres migrations, schema conversion with ora2pg and AWS DMS, and demos of running concurrent… | ||
| You Should Be Standing Here: Learning to Present Sessions | Grant Fritchey | 50m |
Explains concrete steps: pick a clear title and try multiple abstracts so selection rates improve, build slides with huge fonts and high contrast, test and… | ||
| Lead People, Manage Databases | Clay Jackson | 50m |
Practical management advice tied to concrete outcomes: a one‑time purchase of a $50,000 monitoring tool identifies bad SQL, fixes slow monthly check runs and… | ||
| Debugging Life Balance & Work-Life Integration Workshop | Marguerite Clark | 58m |
Interactive workshop guides participants through box breathing and a five‑to‑minute decompression routine, a wheel of health self‑inventory (rate sleep… | ||
| Mastering Communication for Database Professionals: Up, Down & Lateral | Jonah Harris | 28m |
Argues that technical merit loses unless communication matches direction: use SCQA three-slide pitch and lead with business impact when communicating upward… | ||
| PostgreSQL Index Strategy Guide | Greg Dostatni | 52m |
Shows concrete measurements from a 26 GB test table with 12 GB shared_buffers and explains when indexes reduce IO versus when planner prefers a sequential scan… | ||
| Code Your Way Out of Burnout | Malika Boukhelifa | 31m |
Burnout is framed as a systemic, gradual failure: WHO-classified since 2019, a 200-engineer study finds 60% of engineers experience it, and a January 2025… | ||
| Rules of Indexing in PostgreSQL | Alan Zakrzewski | 37m |
Covers concrete index choices and measured wins: using B-Tree INCLUDE columns turns a 0.15s nested-loop into a 0.05s index-only scan; adding an ORDER BY column… | ||
| Scaling PostgreSQL Change Data Capture Using Open Source Airbyte | Rodi Reich Z | 15m |
Airbyte implements a WAL Acquisition Synchronization System that alternates partial snapshots with continuous WAL reads so long-running initial selects never… | ||
| Always Online or Bust | Shaun Thomas | 01h 01m |
Shows a full, zero-downtime upgrade path from Postgres 16 to 17 for a three‑node HA cluster using logical replication and a schema-only pg_dumpall… | ||
| PostgreSQL Upgrades with Logical Replication & Minimal Downtime | Ildefonso C | 01h 41m |
Walks through upgrading PostgreSQL 13→17 by creating per-table publications and a subscription, copying schema and globals with pg_dump, and using pgBackRest… | ||
| Scaling PostgreSQL: Horizontal vs. Vertical | Ibrar Ahmed | 55m |
Compares concrete tuning and replication choices: tune shared_buffers 25–40% (can be higher), set work_mem is per session and multiplies (e.g., raising… | ||
| You’ve Got Bugs! A Workshop on Applying the Development Model to Life | Amanda N | 29m |
Maps the software development lifecycle onto personal wellness: uses requirements gathering to define a vision for “best health,” Duke Integrative Medicine’s… | ||
| Rewiring for Resilience: Hacking Neural Pathways for Peak Performance | Megan D | 46m |
Explains neuroplasticity with concrete measures: repeated practice boosts synapses and myelin, speeding signals up to 100×; one person practices five minutes… | ||
| A Look Into Quantum-Safe Postgres | Tim Steward | 37m |
Claims that quantum reduces brute force times from weeks or months to days or hours, cites IBM Cucabaro at 4,158 qubits and predicts cloud quantum access in… | ||
| Proper PostgreSQL Parameters to Prevent Poor Performance | Greg Dostatni | 45m |
PostgreSQL tuning focuses on a handful of settings that actually change behavior: set shared_buffers to about 25–40% of RAM on a dedicated box to cut reads… | ||
| AutoVacuum - Tuning and Monitoring | Lloyd Albin | 47m |
Postgres autovacuum often leaves tables and indexes bloated until a restart or restore masks the problem; a practical fix is autovacuum_cost_delay 20ms→2ms… | ||
| Top 5 PostgreSQL Query Tuning Tips | Janis Griffin | 24m |
Five concrete steps: monitor wait time at the statement level to spot IO or locking hotspots; run EXPLAIN ANALYZE and read actual rows/loops to find expensive… | ||
| Parallel Processing in PostgreSQL | Raj J, Rajeev T | 22m |
Explains PostgreSQL’s parallel architecture (gather plus workers), the optimizer costs that choose parallel vs serial (notably parallel_tuple_cost and… | ||
| Beyond PostgreSQL 17 | Vibhor Kumar | 49m |
Seven concrete DBA workarounds for Postgres 17 are described: native logical replication now preserves replication slots so you can perform near zero downtime… | ||
| pgvector Newbie to Expert | Rajeev Thottathil, Raj Jayakrishnan | 52m |
Practical roadmap for running pgvector on PostgreSQL: install the extension, store embeddings (demo loads 86 session chunks using Amazon Titan and LangChain)… | ||
| PostgreSQL’s Journey to Distributed Databases | Sameer M, Steve A | 49m |
Shows how Spanner, Yugabyte, Cockroach, Cosmos DB for Postgres and Aurora actually implement distributed Postgres: Spanner uses 8 GB splits, TrueTime and Paxos… | ||
| Reliable Data Replication from Postgres on Kubernetes | Sanketh B | 39m |
Datadog builds a scalable pipeline to replicate Postgres on Kubernetes to arbitrary targets using Debezium + Kafka Connect (preferring it over native logical… | ||
| Highlight from | Ryan Booz | 01m |
Representing Redgate as a Postgres Advocate, attends Postgres Conference to collect concrete, actionable updates on database DevOps and Postgres ecosystem… | ||
| nothing matches | ||