postgres=# select * from sessions where video_id = 'ggXAxBhRvoc';
Hacking Postgres — Andrey, Kirk, Nikolay
Review UUIDv7 and build deterministic transaction_timeout tests.
session summary
The first section reviewed UUIDv7's evolving RFC, monotonic counter, distributed generation, timestamp extraction, and blocked core support. They also surveyed transaction-timeout and SLRU-locking work. The hands-on section tackled flaky transaction-timeout tests by combining injection points with a background psql watch loop. Testing uncovered false success from malformed watch parameters and a broken-pipe cleanup problem when timeout killed psql. The harness remained unfinished, needing a reliable way to detect whether the background session is active.
timecodes
- UUIDv7 status and the evolving RFC
- Monotonic counters and distributed generators
- Why UUIDv7 combines ordering and randomness
- Timestamp extraction and partitioning
- SLRU locking and subtransaction edge cases
- Transaction timeout lands, tests remain flaky
- Replacing fixed sleeps with injection points
- False success, broken pipes, and unfinished cleanup