(depesz) Recent release of new versions of PostgreSQL suggests that you do reindex of all indexes. But this will take a while, and since we don’t actually have ‘REINDEX CONCURRENTLY’ command – it’s a bit tricky.
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help