An unexpected find that freed 20GB of unused index space in PostgreSQL
Too bad MySQL does not have partial indexes.We have one huge table I want to add some indexes for specific cases (for max 1% of records) but server will not have enough memory for it if I add those indexes for all records :/