Peter V Geoghegan
where else to find them
what they talk about
where they keep going back
- PGConf Silicon Valley2 editions2015–2016
all 5 in the filters
on a stage with
never shared a talk
who talks about the same things
- Magnus Hagander25 talks
- Andres Freund15 talks
- Christophe Pettus14 talks
- Simon Riggs19 talks
- Bruce Momjian52 talks
- Hamid Quddus Akhtar9 talks
| title | conference | date |
|---|---|---|
| Multidimensional search strategies for composite B-Tree indexes | PGConf.dev 2025 | 2025-05-13 |
Adds Postgres 18 nbtree skip scan that treats composite B‑tree indexes as multidimensional and turns some full index scans into a series of small index… | ||
| Sort vs Hash A Duality | PGConf Silicon Valley 2016 | 2016-11-14 |
Claim: OLTP gets single-digit‑ms performance on seven‑join queries by using nested loop + B‑tree index lookups that are effectively independent of dataset… | ||
| Breakout Session | PGConf Silicon Valley 2015 | 2015-11-17 |
PostgreSQL 9.5 adds a concrete UPSERT: an INSERT ... ON CONFLICT clause that either inserts or updates without racey subtransaction hacks and with better… | ||
| Concurrency in Postgres | PostgresOpen 2013 | 2013-09-16 |
Explains exactly which SQL isolation levels map to which visibility rules and guarantees and shows the specific locks acquired on tables indexes rows… | ||
| A Batch of Commit Batching | Postgres Open 2012 | 2012-09-17 |
PostgreSQL 9.2 introduces a lock and fast‑path change that makes PostgreSQL 9.2 group commit batch hundreds of logical commits into one fsync, yielding… | ||
| PL/Python -- Python inside the PostgreSQL RDBMS | EuroPython 2011 | 2011-06-20 |
PL/Python embeds Python into PostgreSQL with a single C file under 5,000 lines, maps SQL types to Python, and supports triggers, table-returning functions and… | ||
| nothing matches | ||