Обсуждение: 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