Re: vacuum/reindex

From: Rob Sargent <robjsargent(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: vacuum/reindex
Date: 2019-06-14 20:19:51
Message-ID: c7136ebf-465f-b2c0-d6a5-ee23949a235b@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Leandro Guimarães 2019-06-14 21:04:35 Copy Bulk Ignore Duplicated
Previous Message Ron 2019-06-14 20:13:00 Re: vacuum/reindex