vacuum full post 9.0 - reindex needed?

From: "Anand Kumar, Karthik" <Karthik(dot)AnandKumar(at)classmates(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: vacuum full post 9.0 - reindex needed?
Date: 2015-01-28 20:39:47
Message-ID: D0EE8916.C0E77%karthik.anandkumar@classmates.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

~Karthik

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Guillaume Lelarge 2015-01-28 20:48:19 Re: vacuum full post 9.0 - reindex needed?
Previous Message Day, David 2015-01-28 20:23:37 Re: segmentation fault postgres 9.3.5 core dump perlu related ?