News for hackers. Stuff that matters.

A comment on Show HN: Honker – Postgres NOTIFY/LISTEN Semantics for SQLite.

Re:Show HN: Honker – Postgres NOTIFY/LISTEN Semantics for SQ... by Oxlamarr on Friday April 24, 2026 @06:00AM (#47888014)
Very cool. Is the bottleneck under load mostly SQLite write throughput, or the WAL notification layer?
[ Parent | on HN ]
Re:Show HN: Honker – Postgres NOTIFY/LISTEN Semantics for SQ... by russellthehippo on Friday April 24, 2026 @07:11AM (#47888571)
writes and claim/ack flow. really depends on your journal mode and synchrnous mode as well.

notifs are extremely cheap, either in the old stat(2) mode or the new PRAGMA page_version (see my update on feeback comment). Some other comments mentioned that stat(2) is about 1µs.

[ Parent | on HN ]