Index types supported in Amazon Aurora PostgreSQL and Amazon RDS for PostgreSQL using extensions (SP-GiST, Btree_Gin and Btree_Gist)

Part three of the indexing series examining extension-based strategies for Aurora PostgreSQL and RDS. SP-GiST indexes support partitioned search trees, btree_gin enables unified GIN indexing across mixed column types, and btree_gist handles exclusion constraints effectively.