Jonathan S. Katz
where else to find them
no profile links on file
what they talk about
all 8 in the filters
where they keep going back
- PGConf.dev2 editions2024–2025
- PostgreSQL Conference Europe2 editions2023–2024
- PGConf NYC2 editions2021–2022
all 9 in the filters
on a stage with
- Melanie Plageman2×
- Abhi Shelatonce
- Amit Kapilaonce
all 15 in the filters
who talks about the same things
- Bruce Momjian52 talks
- Magnus Hagander25 talks
- Ibrar Ahmed12 talks
- Sarah Conway5 talks
- Will Leinweber13 talks
- Jobin Augustine9 talks
| title | conference | date |
|---|---|---|
| Vector search is now boring, but PostgreSQL has ways to go | PGConf.dev 2025 | 2025-05-13 |
pgvector extension adds a vector type and custom indexes and yields up to ~150x faster index builds compared to earlier versions, making HNSW defaults work for… | ||
| Opening Session | PGConf.dev 2025 | 2025-05-13 |
Conference opens with logistics: venue Wi‑Fi is available via Wi‑Fi QR codes and t‑shirts and sponsor swag sit at registration; lightning talk signups close… | ||
| Dissimilarity search... | PostgreSQL Conference Europe 2024 | 2024-10-22 |
PGVector implements IVFFlat and HNSW inside PostgreSQL, trading a fixed 8KB page layout and TOAST constraints against in-memory ANN behavior. Builds sample… | ||
| Vectors: how to better support a nasty data type in PostgreSQL | PGConf.dev 2024 | 2024-05-28 |
Explains concrete engineering: pgvector extensions (versions 0.5, 0.6, 0.7) add IVF‑flat and HNSW indexing, SIMD/CPU dispatch and parallel index builds that… | ||
| Welcome & Opening | PGConf.dev 2024 | 2024-05-28 |
Conference opens with logistics: an evening Rogue West bar social with board games and food, a morning student breakfast, workshops (many signed up) and a… | ||
| Vectors are the new JSON | PostgreSQL Conference Europe 2023 | 2023-12-12 |
PostgreSQL already stores vectors via the pgvector extension, adding a vector type plus IVF‑flat and HNSW indexes; common embeddings are 1,536‑dim (~6 KB each)… | ||
| The journey towards active-active replication in PostgreSQL | PostgreSQL Conference Europe 2023 | 2023-12-12 |
PostgreSQL moves from single-primary setups toward multi-primary capability by extending logical replication: Postgres 16 adds bidirectional replication via… | ||
| Keynote: Contributing to Critical Open Source Projects: Lessons from PostgreSQL | Open Source Summit Europe 2023 | 2023-09-19 |
AWS reports a dramatic increase in contributions to PostgreSQL over the past two years and helps land features in PostgreSQL 16 released a week ago; work… | ||
| The journey towards active replication in PostgreSQL | PGCon 2023 | 2023-05-30 |
Progress on PostgreSQL’s logical replication is mapped to concrete features and upgrades: logical decoding and replication slots (9.4), pgoutput and… | ||
| Building a better PostgreSQL together | PGConf NYC 2022 | 2022-09-22 |
Overview of concrete changes and roadmaps: announces Amazon RDS Multi-AZ with two readable standbys, claiming 2× faster commit latency and failovers typically… | ||
| Get Your Insecure PostgreSQL Passwords to SCRAM! | Percona Live 2022 | 2022-05-16 |
PostgreSQL stores passwords with SCRAM-SHA-256 using PBKDF2-style hashing (default iterations=4096 and a 16‑byte salt) so servers keep only stored and server… | ||
| Road to Percona Live 2022 - Jonathan Katz | Percona Live 2022 | 2022-05-16 |
PostgreSQL 10 introduces SCRAM-SHA-256 so passwords can be verified without ever exchanging the secret and channel binding defends against MITM attacks, with… | ||
| Get Your Insecure PostgreSQL Passwords to SCRAM! | PGConf NYC 2021 | 2021-12-02 |
Shows why PostgreSQL passwords must move to SCRAM and demonstrates the actual upgrade steps and failures avoided: building a SCRAM verifier with a 16 byte… | ||
| All Your Queries Are Belong to Us: The Power of File-Injection Attacks... | USENIX Security '16 | 2016-08-10 |
Shows concrete file-injection attacks that recover encrypted search queries by sending crafted documents and observing which injected files appear in results… | ||
| The Cut-and-Choose Game and Its Application to Cryptographic Protocols | USENIX Security '16 | 2016-08-10 |
Claims that cut-and-choose parameter selection is a constrained optimization problem and gives equilibrium analyses and practical solvers; models differing… | ||
| On Beyond Data Types | PostgresOpen 2014 | 2014-09-17 |
Postgres proves the claims with numbers: creating an expression index on plot area turns a sequential scan into an index scan and speeds queries about 15×; a… | ||
| Lightning Talks | PostgresOpen 2013 | 2013-09-16 |
Ten five‑to‑seven minute demos show concrete tools and outcomes not vague topics. Look for IPython SQL + pandas workflow that runs SQL via SQLAlchemy, assigns… | ||
| Range Types in PostgreSQL 9.2 - Your Life Will Never Be the Same | Postgres Open 2012 | 2012-09-17 |
PostgreSQL 9.2 adds concrete range types (ints, numerics, timestamps, dates) with operators like && (overlaps), functions lower/upper, and GiST indexing so… | ||
| nothing matches | ||