vacuum full post 9.0 - reindex needed?
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?
~Karthik
Hi,
2015-01-28 21:39 GMT+01:00 Anand Kumar, Karthik <
Karthik.AnandKumar@classmates.com>:
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