· 3 min · PostgreSQL, Python, Tools

waxsql: Wax Fruit for Your Query Planner

Generate valid SQL that looks real, nourishes nothing, and never spoils.

0 comments

· 5 min · PostgreSQL

All Your GUCs in a Row: effective_io_concurrency

`effective_io_concurrency` has changed what it means twice—from a harmonic-series spindle count to a direct request depth to a real async I/O control.

0 comments

· 3 min

skygrad: A Place and a Time, Rendered as Sky

Render the sky at any place and moment as a PNG gradient, with zero dependencies and pixel-perfect determinism.

0 comments

· 5 min · PostgreSQL

All Your GUCs in a Row: effective_cache_size

effective_cache_size doesn't allocate memory, reserve RAM, or control runtime behavior—it merely whispers a number to the query planner to make it smarter…

0 comments

· 3 min · PostgreSQL

All Your GUCs in a Row: dynamic_shared_memory_type

Parallel queries in PostgreSQL need shared memory sized at runtime, not startup.

0 comments

· 3 min · PostgreSQL

All Your GUCs in a Row: dynamic_library_path

PostgreSQL 18 finally made extensions truly relocatable by adding `extension_control_path` to match the long-existing `dynamic_library_path`.

0 comments

· 4 min · PostgreSQL

All Your GUCs in a Row: default_transaction_isolation and default_transaction_read_only

PostgreSQL's isolation levels hold surprises: read uncommitted silently becomes read committed, repeatable read forbids phantom reads the standard permits, and…

0 comments

· 4 min · PostgreSQL

All Your GUCs in a Row: default_transaction_deferrable

PostgreSQL's `DEFERRABLE` transaction mode only works with `SERIALIZABLE READ ONLY` transactions, where it waits for a safe snapshot to eliminate…

0 comments

· 4 min · PostgreSQL

All Your GUCs in a Row: default_toast_compression

PostgreSQL 19 switches TOAST compression from pglz to lz4 by default—faster, more efficient, and finally the right call.

0 comments

· 4 min · PostgreSQL

All Your GUCs in a Row: default_text_search_config

PostgreSQL forbids indexing with the default text search configuration because it's mutable—change the setting, and your index silently disagrees with reality.

0 comments