We routinely use plantuner. http://www.sai.msu.su/~megera/wiki/plantuner On Tue, May 20, 2014 at 12:38 PM, Steve Crawford <scrawford@xxxxxxxxxxxxxxxxxxxx> wrote: > Is there a way to force a specific index to be removed from consideration in > planning a single query? > > Specifically, on a 60-million-row table I have an index that is a candidate > for removal. I have identified the sets of nightly queries that use the > index but before dropping it I would like to run EXPLAIN and do timing tests > on the queries to see the impact of not having that index available and > rewrite the query to efficiently use other indexes if necessary. > > Cheers, > Steve > > > > -- > Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general
