From the archive
Wednesday, 4 November
Folded from 15 sources that day.
Sorted by quality and by how many sources covered it, the same for everyone.
-
Burnt TOAST
Explains how PostgreSQL's TOAST moves oversized column values into a side table, and why this makes fetches and writes slow for large text or JSON columns.
-
Arrows to Arrows, Categories to Queries
Introduces catlang, a category-theory-based language whose compiler emits one giant SELECT statement that Postgres runs to produce the program's output.