Re: vacuum/reindex - Mailing list pgsql-general

From Rob Sargent
Subject Re: vacuum/reindex
Date
Msg-id c7136ebf-465f-b2c0-d6a5-ee23949a235b@gmail.com
Whole thread Raw
In response to Re: vacuum/reindex  (Ron <ronljohnsonjr@gmail.com>)
List pgsql-general
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





pgsql-general by date:

Previous
From: Ron
Date:
Subject: Re: vacuum/reindex
Next
From: Leandro Guimarães
Date:
Subject: Copy Bulk Ignore Duplicated