-- Q: What indexing advantages does PostgreSQL have over MySQL?
-- A: PostgreSQL natively supports a massive variety of indexes out of the box:
-- B-Tree (default), Hash, GiST, SP-GiST, GIN, and BRIN.
-- MySQL primarily relies on B-Tree (and Full-Text/Spatial). 
-- PostgreSQL's GIN is perfect for JSON/Arrays, and BRIN is incredible 
-- for massive time-series tables to save memory.