PostgreSQL provides several index types like Hash, B-tree, SP-GiST, BRIN, and GIN. All these types uses a separate algorithm that is best suited to queries.

BY Best Interview Question ON 04 Jul 2020