Lightning Talks
summary
A rapid sequence of practical updates and demos: BM25: 500k Quora → SQL: minutes, PL/Rust array agg: ~3s, PGX custom aggregate: ~1s showing how far Postgres can go on text scoring; a performance farm that auto-tests patches and produces charts; Oracle→Postgres migration notes with >1,000 execute immediate fixes and heavy app SQL automation; pg_duckdb v0.1: parquet read/write, join Postgres tables, TPC‑DS example 10m→450ms; GitHub Actions runners cut CI cost ~10x; repmgr standby clone + switch over yields seconds of downtime; WAL‑G integrity checks, cloud images/snapshots, and PGCA trademark/donation details.
AI-written summary · about
chapters (15)
- 0:00Welcome to lightning talks
- 1:03New speaker selection system
- 6:57Implementing BM25 in PostgreSQL
- 10:55PostgreSQL performance farm
- 11:39Migrating to PostgreSQL challenges
- 14:52Cost reduction with GitHub Actions
- 18:07PG DuckDB extension overview
- 23:29JSONB type limitations and needs
- 26:56Zero-downtime PostgreSQL migration
- 31:34Conference website redesign
- 36:08Ensuring backup reliability
- 41:52Community recognition initiative
- 45:03Running PostgreSQL on cloud
- 49:40PostgreSQL journey and board
- 55:27Closing remarks
