· 50:53 · youtube ↗
Back to “log LSN on DROP TABLE”
Fix correctness and coverage of recovery landmarks for destructive DDL.
active
direct mapping
postgres@hacking:~$ ls people/nikolay-samokhvalov/sessions/
Nikolay Samokhvalov
PostgreSQL Significant Contributor ↗Host and Postgres hacker. 45 sessions in the public archive.
direct mapping
· 77:12 · youtube ↗
Agent hacking Postgres
Agent-assisted patch work around the wait-event timing submission.
active
correlated mapping
· 93:47 · youtube ↗
Wait-event tracing
Independent benchmarks, observer effect, coverage, and patch restructuring.
active
direct mapping
· 78:11 · youtube ↗
Agentic Hacking Postgres
End-to-end tests for archive-fed logical decoding and pause/resume behavior.
active
direct mapping
· 53:58 · youtube ↗
Logical replication from physical standbys on WAL shipping
Refine recovery pause behavior, crash safety, promotion, and auto-resume.
active
direct mapping
· 93:07 · youtube ↗
Hacking Postgres with Andrey, Kirk, Nik
Pause replay instead of invalidating conflicting logical slots; design auto-resume.
active
direct mapping
· 39:42 · youtube ↗
Logical decoding of archived WALs
Use an archive-fed standby as a logical-decoding engine.
active
direct mapping
· 55:36 · youtube ↗
Hacking Postgres with Kirk, Andrey, Nik
Generic-title workshop; public metadata does not identify a deliverable.
exploration
none mapping
· 60:51 · youtube ↗
Precise wait-event tracing, part 2
Low-overhead per-event timing and trace capture.
active
direct mapping
· 60:12 · youtube ↗
Wait-event tracing, part 1
pg_wait_tracer, core timing, USDT probes, and observer-effect trade-offs.
active
direct mapping
· 94:41 · youtube ↗
Command-tag customization
Custom protocol command tags and _pq_ capability negotiation.
active
direct mapping
· 72:37 · youtube ↗
AI or not AI; GSoC 2026; improving pglz compression
Evaluate agentic hacking and experiment with pglz compression.
exploration
direct mapping
· 69:49 · youtube ↗
exploration
direct mapping
· 87:51 · youtube ↗
How to create Postgres patches with AI?
AI-assisted patch discovery, implementation, review, and submission.
exploration
direct mapping
· 73:44 · youtube ↗
Vibe Hacking Postgres
Generic workshop; same-day work started pg_stat_statements row accounting.
exploration
correlated mapping
· 87:51 · youtube ↗
Hacking Postgres
Generic workshop; nearby fork activity covered wait-event gaps and MultiXact.
exploration
correlated mapping
· 88:38 · youtube ↗
WHERE support for REFRESH MATERIALIZED VIEW
Partial refresh restricted by a predicate, including concurrency semantics.
active
direct mapping
· 70:24 · youtube ↗
exploration
none mapping
· 51:42 · youtube ↗
exploration
none mapping
· 97:08 · youtube ↗
Index bloat and B-tree page merge, part 3
Continue page-merge implementation and correctness work.
exploration
correlated mapping
· 75:39 · youtube ↗
Index bloat and B-tree page merge, part 2
Continue B-tree page-merge design and prototype.
exploration
correlated mapping
· 84:02 · youtube ↗
Index bloat and B-tree page merge, part 1
Merge sparse sibling B-tree pages to reduce bloat.
exploration
direct mapping
· 71:56 · youtube ↗
committed
direct mapping
· 81:56 · youtube ↗
Vibe Hacking with Dmitry Fomin
Wait-event observability and precise tracing ideas.
active
correlated mapping
· 80:32 · youtube ↗
Vibe Hacking Postgres
Generic workshop near the start of the MultiXact standby-deadlock thread.
committed
correlated mapping
· 87:17 · youtube ↗
exploration
none mapping
· 73:25 · youtube ↗
exploration
none mapping
· 80:57 · youtube ↗
exploration
none mapping
· 74:57 · youtube ↗
exploration
none mapping
· 74:59 · youtube ↗
Hacking Postgres with Andrey and Nik
Generic-title workshop; no public deliverable confidently mapped.
exploration
none mapping
· 48:43 · youtube ↗
Include ANALYZE steps in all dumps, part 2
Continue design and patch work on dump-time analysis.
exploration
direct mapping
· 44:37 · youtube ↗
Include ANALYZE steps in all dumps, part 1
Preserve or trigger statistics collection in dump/restore output.
exploration
direct mapping
· 108:13 · youtube ↗
Simplify recovering from a DROP TABLE
Log a recovery landmark when destructive DDL commits.
active
direct mapping
· 86:12 · youtube ↗
exploration
correlated mapping
· 93:53 · youtube ↗
Hacking Postgres — Andrey, Kirk, Nikolay
Generic-title workshop; public metadata does not identify a deliverable.
exploration
none mapping
· 55:46 · youtube ↗
stalled
correlated mapping
· 64:33 · youtube ↗
B-tree build and batching WAL records
Batch or compress WAL records during B-tree construction.
stalled
correlated mapping
· 64:25 · youtube ↗
exploration
correlated mapping
· 63:53 · youtube ↗
Observer effect in pg_stat_statements and pg_stat_kcache
Missing and self-hidden I/O accounting in monitoring extensions.
active
direct mapping
· 50:41 · youtube ↗
Configurable command tag, part 1
Explore custom command-completion tags returned to clients.
active
correlated mapping
· 44:28 · youtube ↗
Postgres Hacking 101 with Andrey
Follow-up workshop likely reviewing the bounded psql \watch work.
committed
correlated mapping
· 56:56 · youtube ↗
Postgres Hacking 101: \watch with limited loops
Add a maximum iteration count to psql \watch.
committed
direct mapping
· 59:00 · youtube ↗
Hacking Postgres 101 — ULID function
The ULID exercise evolved into PostgreSQL's UUIDv7 implementation.
committed
direct mapping
· 51:28 · youtube ↗
Postgres Hacking 101: prevent unqualified DML
Prototype GUCs rejecting unqualified UPDATE and DELETE.
stalled
direct mapping
· 44:59 · youtube ↗
Implementing transaction_timeout
Add a timeout for any transaction lasting too long.
committed
direct mapping