Lightning Talks
summary
Eleven five‑minute updates cover concrete results and tools: a Prometheus‑focused extension converts slow monitoring queries into materialized views with scheduled refreshes; a Python program renders filesystem data into images; SQL Standards WG targets a 2027 draft and notes identifier length rising to 128; RPM packaging supports many distros but faces dependency churn; pg_query ships C bindings and Windows support; a new Table AM multi‑insert speeds many workloads by ~36–52% (up to 68% less wall time); vacuum stats logging patch, nanosecond timing overhead measurements, a YAML test runner pg_ygress, an upcoming pgAutoDBA, and a partial aggregate pushdown that scales aggregation across FDW workers.
AI-written summary · about
chapters (13)
- 0:00Introduction to Lightning Talks
- 0:54Monitoring with materialized views
- 3:16Turning data into art
- 6:05SQL standards update
- 10:48State of PostgreSQL RPMs
- 15:42PG Query project overview
- 19:41Multi-insert table access method
- 23:34Vacuum statistics proposal
- 27:44Query timing overhead analysis
- 31:06Testing PostgreSQL extensions
- 35:49Automating database administration
- 39:58Partial aggregate push down
- 44:43Conference wrap-up and announcements
