Re: index question - Mailing list pgsql-general

From David G. Johnston
Subject Re: index question
Date
Msg-id CAKFQuwZCAn47kONL3zxUwH93UEXH4t_FQB4gQ24f7g==Ub2eJg@mail.gmail.com
Whole thread Raw
In response to Re: index question  (Sameer Kumar <sameer.kumar@ashnik.com>)
Responses Re: index question
List pgsql-general
I am not sure, but I think if the size of index is very huge and you suspect they are not being used, you might want to check the bloats percentage in the index. If this is true, perhaps a reindex might help.

If they aren't being used just drop them.  Its when they are used and get bloated that you are in trouble.

There are recipes for bloat calculation out there that are worth investigating.​
 

​David J.​

pgsql-general by date:

Previous
From: "drum.lucas@gmail.com"
Date:
Subject: Re: Function PostgreSQL 9.2
Next
From: "David G. Johnston"
Date:
Subject: Re: Function PostgreSQL 9.2