partial index — 2 Technical Articles

Mar 1, 2026 · Databases

Enforcing Unique Emails with Soft Delete: Partial Indexes & Generated Columns

This article explains why ordinary unique constraints fail with soft‑deleted rows, and shows how to maintain email uniqueness by using partial unique indexes in PostgreSQL or generated‑column‑based unique indexes in MySQL/MariaDB, including multi‑tenant adaptations.

databasesgenerated columnpartial index

0 likes · 7 min read

Enforcing Unique Emails with Soft Delete: Partial Indexes & Generated Columns

ITPUB

Jul 17, 2016 · Databases

Combine Partial BTREE and BRIN Indexes in PostgreSQL for Space Savings and Speed

This article demonstrates how PostgreSQL's Partial Index feature can be used together with BTREE and BRIN indexes to dramatically reduce storage while maintaining high query performance on both low‑frequency and high‑frequency data in a heavily skewed dataset.

BRINBTreeDatabase Performance

0 likes · 8 min read

Combine Partial BTREE and BRIN Indexes in PostgreSQL for Space Savings and Speed