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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
