On Sun, Jan 5, 2014 at 2:19 PM, Gavin Flower <[email protected]> wrote: > 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?
I fully agree. This is the matter of implementation. -- Kind regards, Sergey Konoplev PostgreSQL Consultant and DBA http://www.linkedin.com/in/grayhemp +1 (415) 867-9984, +7 (901) 903-0499, +7 (988) 888-1979 [email protected] -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
