How Partial, Covering, and Multicolumn Indexes May Slow Down UPDATEs in PostgreSQL

As cited in DDIA

Nikolay Samokhvalov. "How Partial, Covering, and Multicolumn Indexes May Slow Down UPDATEs in PostgreSQL." postgres.ai, October 2021. Archived at perma.cc/PBK3-F4G9

How the page describes itself

How partial, covering, and multicolumn indexes may slow down UPDATEs in PostgreSQL | PostgresAI

<a href="https://postgres.ai/blog/20211029-how-partial-and-covering-indexes-affect-update-performance-in-postgresql"><img src="https://postgres.ai/assets/thumbnails/20211029-how-partial-and-covering-indexes-affect-update-performance-in-postgresql.jpeg" alt="How partial, covering, and multicolumn indexes may slow down UPDATEs in PostgreSQL"/></a> <p>Based on a true story.</p> <p>This article was or…

From the page's own metadata at postgres.ai, 2026-08-29.

Link check

Status

Link checked and reachable (HTTP 200)

Format

text/html

Size

0.1 MB

Last checked

2026-08-29

Identifiers and archived copies

perma.cc

https://perma.cc/PBK3-F4G9