Database

Articles about Database.

Browse by category

There are currently 8 articles in this category. Start with any entry and expand through tags when you want nearby topics.

How far can a Lua-integrated psql go? Inside the VACUUM progress wrapper

An experimental patch embeds Lua in psql so users can define client-side behavior. Using its VACUUM wrapper as the concrete example, this article explains the two-connection monitoring design, the meaning of PostgreSQL progress fields, and the compatibility checks required before testing it.

Database New technology

2026-09-01

Lua Integration Patch Brings Custom Backslash Commands to psql

An experimental patch integrates Lua into psql so users can define their own backslash commands. Using a custom `\my.dt` command that sorts tables by size, this article examines the new extension model and the practical choices available today.

Database New technology

2026-08-27

Choosing UUIDv7 for Primary Keys in PostgreSQL 18

PostgreSQL 18 includes uuidv7() for generating time-ordered UUIDs. This article explains how UUIDv7 changes B-tree behavior compared with UUIDv4, the tradeoff of exposing time information, and a measured path for adopting it in existing tables.

Database Postgresql

2026-08-27

Isolating PostgreSQL JIT Failures with Two GUCs

A PostgreSQL diagnostic technique uses jit_expressions and jit_tuple_deforming to narrow suspected JIT crashes or wrong results to expression compilation or tuple deforming. This article explains their asymmetric relationship and a controlled reproduction procedure.

Database Postgresql

2026-08-17

Why HA Does Not Make a Long PostgreSQL checkpoint_timeout Safe

A longer PostgreSQL checkpoint_timeout can increase WAL replay exposure not only on the primary but also when a standby restarts. This article explains why HA is not a substitute for recovery-time control and connects checkpoints, restartpoints, monitoring, and failure drills into one availability decision.

Database Postgresql

2026-08-16

How PostgreSQL ignore_system_indexes Enables Recovery from Catalog Index Corruption

PostgreSQL's `ignore_system_indexes` setting removes damaged system catalog indexes from the read path so an operator can reach `REINDEX SYSTEM`. This article connects `-P`, single-user recovery, version differences, and post-repair verification.

Database Postgresql

2026-08-16

Why PostgreSQL COUNT(DISTINCT) cannot use parallel aggregation—and how to rewrite it

PostgreSQL cannot use parallel aggregation when an aggregate call contains DISTINCT. Using the primary source’s execution plans and benchmark as the starting point, this article explains a GROUP BY rewrite, NULL semantics, and what to validate with EXPLAIN.

Database Postgresql

2026-08-06

Reading PostgreSQL platform trust through the CALM Platform Test

Vibhor Kumar wrote "The CALM Platform Test" to frame enterprise platform readiness through four dimensions: Changeability, Assurance, Leverage, and Measurability. Read with PostgreSQL logical replication, RLS, pgAudit, pgvector, and pg_stat_statements in mind, it becomes a practical prompt to verify changeability and evidence before placing AI workloads on a data platform.

Database Postgresql

2026-07-29