Hi, 2015-01-28 21:39 GMT+01:00 Anand Kumar, Karthik < [email protected]>:
> 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. -- Guillaume. http://blog.guillaume.lelarge.info http://www.dalibo.com
