Postgres: Recreating Indexes supporting Unique, Foreign Key and Primary Key Constraints

I have frequently found myself in situations when I had to reindex a few indexes (because the index got bloated a lot), and I always have to lookup the exact commands, after searching quite a bit, just to be sure that I am doing the right thing and not making a mistake. In the past, … Continue reading Postgres: Recreating Indexes supporting Unique, Foreign Key and Primary Key Constraints