Re: index question

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Sameer Kumar <sameer(dot)kumar(at)ashnik(dot)com>
Cc: "drum(dot)lucas(at)gmail(dot)com" <drum(dot)lucas(at)gmail(dot)com>, Melvin Davidson <melvin6925(at)gmail(dot)com>, Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: index question
Date: 2016-05-03 00:45:38
Message-ID: CAKFQuwZCAn47kONL3zxUwH93UEXH4t_FQB4gQ24f7g==Ub2eJg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.​

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2016-05-03 01:08:41 Re: Function PostgreSQL 9.2
Previous Message drum.lucas@gmail.com 2016-05-03 00:44:45 Re: Function PostgreSQL 9.2