On 06/01/14 11:08, Sergey Konoplev wrote: [...]
An index might be considered as useless when there were no idx scans for the significantly long period. However it might be non-trivial to define this period. Eg. one have a query building an annual report that uses this index and the period here is one year.
[...]
An index only used by an annual report, should possibly be only created prior to the report run & dropped immediately afterwards - why carry its overhead for the bulk of the year?
Cheers, Gavin -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
