Despite the title saying PostgreSQL this doesn&#x27;t go into any PostgreSQL specific topics like function based indexes, or partial indexes.<p>The stuff here is universal and applies to any database (perhaps with some terminology change).