What's New in Python 3.15: Lazy Imports, frozendict, Tachyon, and More
Python 3.15 makes startup cheaper, UTF-8 the default, and ships a sampling profiler you can attach to a running process.
Posts
All posts published on this site.
Everything published here, newest first.
PostgreSQL's time and timetz Implementation in C
time is 8 bytes of microseconds since midnight, timetz adds a 4-byte zone offset, and the 16-byte C struct only ever copies its first 12 bytes into a tuple.
tmux Parses Escape Sequences Fast: Four Boring Optimisations That Matter
tmux’s parser has no clever trick in it. It’s a state machine with a transition cache, a bsearch(), a trie, and a width cache — four small optimisations, each of which swaps an…
PostgreSQL Speeds Up Hash Joins: Specialising the Expression Interpreter
PostgreSQL pattern-matches a hash join’s compiled expression steps and swaps the general-purpose interpreter for a specialised C function, which is worth up to 20% on probe-heavy …
PostgreSQL's numeric Implementation in C: Exact Decimals, Two Different Formats
numeric stores exact decimals as base-10000 digits with an explicit weight — and an in-memory form that reserves a spare leading digit so a carry never forces a realloc.