The PostgreSQL Guide to Partial Indexes on Soft Deletes

If every hot query ignores deleted rows, stop paying to index them.