PGCon 2023
| title | author | length |
|---|---|---|
| Opening | Dan Langille | 09m |
Wi-Fi is unsecured with OpenVPN on port 1149 (approx) and an open SSH tunnel available for remote access. Sponsors listed include AWS, Crunchy Data, Fujitsu… | ||
| Sorting Out glibc Collation Challenges | Joe Conway | 55m |
Shows that glibc collation changes between OS releases silently corrupt Postgres indexes: upgrading from 2.17 to newer glibc changes sort order, causing… | ||
| Writing a Foreign Data Wrapper | Christophe Pettus | 46m |
Explains how to implement a PostgreSQL foreign data wrapper written in C (with an optional multicorn Python wrapper), what required FDW callbacks are… | ||
| Patroni 3.0: What's New and Future Plans | Alexander Kukushkin | 52m |
Patroni 3.0 adds concrete behavior: a new distributed leader election and discovery protocol using external stores (Consul/etcd) with periodic updates and TTL… | ||
| Visualizing Postgres I O Performance for Development | Melanie Plageman | 53m |
Local benchmarks use pgbench plus PostgreSQL views (pg_stat_io, pg_buffercache, pg_stat_wal, pg_stat_activity), iostat/diastat, pidstat, and /proc/meminfo to… | ||
| Logical Replication of DDLs | Peter Smith, Zheng Li (Zane) | 56m |
Adds DDL replication to PostgreSQL via a new publication parameter ddl and a new WAL record type xlog logical ddl message. Implementation captures DDL with… | ||
| Who's managing the credentials for your database? | Dewan Ahmed | 44m |
Claims that >80% of breaches trace to poor or reused passwords and that Shodan still finds 800,000 PostgreSQL instances publicly accessible. Demo provisions… | ||
| PostgreSQL 16 and beyond | Amit Kapila | 46m |
PostgreSQL 16 adds concrete replication, storage, SQL and ops changes: logical replication from standby and binary initial table copy, parallel apply of large… | ||
| Running a Community Conference | Mark Wong, Stacey Haysler | 46m |
A practical checklist for running a community Postgres conference: plan at least 6 months planning (one event was done in 91 days but not recommended)… | ||
| BRIN improvements and new opclasses | Tomáš Vondra | 44m |
BRIN indexes chunk the heap into ~1MB ranges and store compact summaries so a 3.5GB table yields a BRIN under 1MB versus a B-tree ~50–65MB; on 10M-row tests… | ||
| PgBouncer: Present and Future | Euler Taveira | 53m |
PgBouncer is a lightweight C connection pooler (≈26,000 LOC) using libevent and libyajl, with 48 releases, 55 contributors and three active committers; it… | ||
| A Pattern for a Searchable, Encrypted JSON Document Service | David E. Wheeler | 57m |
A searchable, encrypted JSON document service is built on Postgres using Tink AEAD encryption and KMS-rooted keyrings, storing only a plaintext UUID plus an… | ||
| Adding PG15 Support to Citus Extension | Abdullah Hanefi Önaldı, Naisila Puka | 39m |
Citus gains PostgreSQL 15 compatibility by updating build logic and about a dozen internals, including replacing the removed ValueNode, adapting… | ||
| PGTracer: A Tracing Tool for Postgres Backends | Ronan Dunklau | 46m |
PGTracer is a root-run tool that uses eBPF plus DWARF debug symbols to attach to a running Postgres backend, dump live query text, buffer and IO stats, and… | ||
| What Timescale's Approach to Dropping Chunks Tells Us About Concurrent DDL | Christopher Travers | 43m |
Timescale implements chunk drops by removing entries from its internal catalog and using custom planner hooks so it takes a lighter lock on the parent (share… | ||
| Configuration and Authentication | Michael Paquier | 54m |
Postgres supports many auth methods but the practical takeaways are concrete: never use trust or cleartext; prefer scram-256 (added in PG10) and require SSL… | ||
| IPC in PostgreSQL | Thomas Munro | 47m |
Postgres moves from polling and blocking IO toward precise nonblocking wakeups using a check_for_interrupt cooperative hook, shared-memory latches (added 2010)… | ||
| The journey towards active replication in PostgreSQL | Amit Kapila, Jonathan S. Katz | 53m |
Progress on PostgreSQL’s logical replication is mapped to concrete features and upgrades: logical decoding and replication slots (9.4), pgoutput and… | ||
| Intro to Postgres Hacking via Temporal Tables | Paul A Jungwirth | 46m |
Adds SQL:2011-style application-time temporal support by implementing for a portion of DML: defines a period on a table, temporal PK/unique constraints… | ||
| Automating Index Selection Using Constraint Programming | Lukas Fittl, Philippe Olivier | 49m |
An open source constraint programming model converts PG stat statements workloads into per-table scans, uses hypoPG to get hypothetical planner costs and… | ||
| PostgreSQL is Nowhere Near Ready | Hannu Krosing | 42m |
Argues four concrete fixes with runnable results: add UNION DISTINCT ON to avoid generating 3,877 alternate paths on a 114×41 grid (turning an exponential… | ||
| Logical Replication handling of large transactions | Hou Zhijie, Hayato Kuroda | 39m |
Covers how PostgreSQL moves from PG12’s temp-file-per-large-transaction (publisher-side spill) to PG13’s memory cap logical_decoding_work_mem=64MB (default… | ||
| GiST news and prospects | Andrey Borodin | 34m |
GiST sees concrete gains: predicate locking reduces serializable conflicts, covering columns in Postgres 12 let non-indexable columns be returned by index-only… | ||
| Continuous Aggregates A Use Case of Materialized Views | Fabrízio de Royes Mello, Rafia Sabih | 37m |
TimescaleDB implements continuous aggregates that incrementally refresh materialized results by tracking a watermark and applying aggregation only to newly… | ||
| On the Road to TDE | David Christensen, Stephen Frost | 44m |
Proposal adds runtime block-size, a reserved page area and page-feature flags so pages can store an authentication tag and a per-page IV; goal is encrypting… | ||
| Global unique index a different approach | Cary Huang | 41m |
Patch implements a global unique index by keeping one index per partition but building a single long-lived spool and doing a global tape/merge sort to verify… | ||
| Future of table access methods | Alexander Korotkov | 53m |
Postgres gains a concrete patch set to let alternative table access methods do real work: a new enum for row references that adds row ID (an arbitrary byte… | ||
| Parallel Recovery in PostgreSQL | Koichi Suzuki | 50m |
Prototype adds a parallel recovery engine to startup that reads WAL into a shared circular WAL buffer and dispatches records to… | ||
| Closing Session | Dan Langille | 23m |
Closing session lists sponsors, thanks volunteers, and confirms recordings will appear on YouTube in about one to two weeks. A charity auction raises over CAD… | ||
| nothing matches | ||