Postgres Pro
Downloads
Home   >   mailing lists

Re: vacuum full post 9.0 - reindex needed? - Mailing list pgsql-general

From Guillaume Lelarge
Subject Re: vacuum full post 9.0 - reindex needed?
Date
Msg-id CAECtzeXXryR5PvLeD99pQZotohhSdEhwuM9ztVcY=8VGDBgzhw@mail.gmail.com
Whole thread Raw
In response to vacuum full post 9.0 - reindex needed?  ("Anand Kumar, Karthik" <Karthik.AnandKumar@classmates.com>)
List pgsql-general
Tree view
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.


--

pgsql-general by date:

Previous
From: "Anand Kumar, Karthik"
Date:
Subject: vacuum full post 9.0 - reindex needed?
Next
From: Leon Dang
Date:
Subject: Re: Request for review of new redis-fdw module