PostgreSQL's bytea Implementation in C: The Blob with a Settings Knob
bytea’s output format is a session setting, not a property of the type: flip bytea_output and the same stored bytes print as hex or as escapes, with nothing in the table changing.
Posts
All posts published on this site.
Everything published here, newest first.
tmux Batches Terminal Output: One Write() Per Event Loop Iteration
Every byte tmux sends to a terminal goes through one function that appends to a per-client buffer, and that buffer is flushed with a single write() per event loop iteration.
PostgreSQL Computes Page Checksums Fast: Thirty-Two Parallel FNV-1a Hashes
The page checksum runs 32 FNV-1a hashes in parallel over a 32-column view of the page to hide multiply latency — and 32 is baked into the on-disk format.
PostgreSQL's Integer Type Implementation in C: int2, int4, int8
int2, int4 and int8 are one design in three widths — every operator is overflow-checked, so 2147483647 + 1 raises an error instead of wrapping negative.
PostgreSQL Deduplicates B-Tree Entries: Posting Lists and In-Place Splits
B-tree leaves store one posting list tuple per distinct key instead of one entry per row, and an over-long list is split in place inside the insert’s critical section.