Posts tagged “PostgreSQL”
4 posts Subscribe by RSS
4 posts
PostgreSQL transaction ID wraparound: why VACUUM freezes rows and how to read age(datfrozenxid)
What happens when PostgreSQL's 32-bit transaction ID wraps: freezing, relfrozenxid/datfrozenxid, anti-wraparound autovacuum, warnings, write refusal and recovery, per the PostgreSQL 18 docs.
What PostgreSQL data checksums catch, and what they don't
PostgreSQL data checksums detect corrupted pages on read. Covers when checks run, enabling them offline with pg_checksums, pg_stat_database counters, and what amcheck and backups still cover.
PostgreSQL CREATE INDEX CONCURRENTLY: what you pay for not blocking writes
CREATE INDEX CONCURRENTLY's lock, two scans and transaction waits, INVALID index cleanup after failure, and transaction-block and partition limits, per PostgreSQL 18 docs.
When a PostgreSQL UPDATE needs no new index entries: HOT updates and fillfactor
PostgreSQL HOT (heap-only tuple) updates avoid new index entries when no indexed column changes and the page has room. Covers both rules, fillfactor, and pg_stat_user_tables counters.
No posts match. Try another word.