Lightning Talks
summary
Claims and patches land fast: a Postgres variant implements time-based MVCC by recording atomic commit times in the clog and using ClockBound to get bounded clocks so snapshots work across shards (demonstrated at 60 shards and ~2M commits/sec); Intel upstreams AVX512 popcount and proposes x86d_sort with SIMD, showing ~7–10% index/build gains but some regressions on low-cardinality sets; a pgbench option continue-client-on-error keeps clients alive after transaction failures; a buffers distinct HLL sketch turns “13,500 shared hits” into ~13 unique pages.
AI-written summary · about
chapters (13)
- 0:00Welcome and introduction
- 1:17Connecting world with open source
- 6:07Distributed snapshot isolation
- 11:53Hardware acceleration with SIMD
- 17:19Logical replication setup
- 20:52New PGbench client option
- 24:44Becoming part of Postgres community
- 27:13Shared blocks hit distinct
- 31:30Results visualization with ripple
- 34:42Feature engineering with SQL
- 40:03Reluctant user community
- 46:00Postgres for machine learning
- 48:05Q&A and closing
