Thread: vacuum/reindex
Is reindex table redundant after vacuum(analyse,verbose)?
On 6/14/19 2:55 PM, Rob Sargent wrote: > Is reindex table redundant after vacuum(analyse,verbose)? Instead of "redundant", I'd call it "backwards", since doing a vacuum(analyse,verbose) on a freshly reindexed table seems more fruitful. -- Angular momentum makes the world go 'round.
On 6/14/19 2:13 PM, Ron wrote: > On 6/14/19 2:55 PM, Rob Sargent wrote: >> Is reindex table redundant after vacuum(analyse,verbose)? > > Instead of "redundant", I'd call it "backwards", since doing a > vacuum(analyse,verbose) on a freshly reindexed table seems more fruitful. > Does reindex remove (dead) row versions as vacuum does (in the indices)? Maybe I don't need reindex at all as I do NOT suspect any corruption - was just rebuilding after having removed 15M data rows in vacuum