Hi,
--
2015-01-28 21:39 GMT+01:00 Anand Kumar, Karthik <Karthik.AnandKumar@xxxxxxxxxxxxxx>:
I haven’t been able to find clear information online about what happens with existing indexes on a postgres post-9.0 database (we specifically use 9.3) after a vacuum full.
There is a lot of information on how a vacuum differs from a vacuum full, but my question is – is a re-index needed after a full vacuum?
We’ve seen from practice that indexes do work after vacuum fulls, but – will a reindex make them more optimal?
Starting from 9.0, you don't need to REINDEX after a VACUUM FULL.
--
