Andres Freund
where else to find them
what they talk about
all 4 in the filters
where they keep going back
- PostgreSQL Conference Europe3 editions2023–2025
- PGConf.dev2 editions2024–2025
- PGConf Silicon Valley2 editions2015–2016
all 6 in the filters
on a stage with
- Marco Slotonce
who talks about the same things
- Ibrar Ahmed12 talks
- Bruce Momjian52 talks
- Jobin Augustine9 talks
- Simon Riggs19 talks
- Peter V Geoghegan9 talks
- Gabe Enslein2 talks
| title | conference | date |
|---|---|---|
| AIO in PG 18 and beyond | PostgreSQL Conference Europe 2025 | 2025-10-21 |
PostgreSQL 18 adds AIO for reads only via a readstreams layer that currently uses either worker mode (process-based workers) or Linux io_uring; buffered reads… | ||
| What went wrong with AIO | PGConf.dev 2025 | 2025-05-13 |
Five years of work produces a merged core AIO path landing in PG18 but not full write support yet; a prototype using io_uring and later worker mode survives… | ||
| NUMA vs PostgreSQL | PostgreSQL Conference Europe 2024 | 2024-10-22 |
Shows experimental patches that add NUMA visibility, force or interleave shared memory, and change buffer replacement and locking to reduce cross-node… | ||
| Analyzing cacheline contention using perf c2c | PGConf.dev 2024 | 2024-05-28 |
Demonstrates using perf c2c to locate true cacheline contention in Postgres and traces how that led to snapshot scalability work in PG 14. Covers cache… | ||
| The path to using AIO in postgres | PostgreSQL Conference Europe 2023 | 2023-12-12 |
Work toward using asynchronous IO and direct IO in Postgres is already in code: 3x speedup for concurrent COPY in 16, a new streaming read interface for easy… | ||
| Analyzing Postgres performance problems using perf and eBPF | Citus Con: An Event for Postgres 2022 | 2022-04-12 |
Uses perf to find kernel-side hotspots (high CPU in TLS/crypto locks) and shows that upgrading OpenSSL 1.0.2 → 1.1 raises pgbench throughput ~4x and halves… | ||
| IO in PostgreSQL: Past, Present, Future | Vaccination Database Tech Talks (Booster) - Spring 2022 | 2022-01-31 |
Prototype replaces kernel pagecache I/O with an asynchronous layer using io_uring backend plus a worker-process fallback for portability, changes checkpointer… | ||
| Improving Postgres' Efficiency | PostgresOpen Silicon Valley 2017 | 2017-09-06 |
Describes concrete Postgres changes and measured effects: adds multi-column statistics (Postgres 10) to fix huge selectivity errors, uses index-only scans and… | ||
| Durability in Postgres | PGConf Silicon Valley 2016 | 2016-11-14 |
Explains how Postgres actually achieves durability (WAL in 16MB segments, checkpoints that fsync dirty shared_buffers) and what to tune: checkpoint_timeout… | ||
| Tutorial | PGConf Silicon Valley 2015 | 2015-11-17 |
Claims that PostgreSQL can replace multi-stage stacks by delivering real-time dashboards using materialized views, triggers and the HyperLogLog extension on… | ||
| nothing matches | ||