Detect missing combined indexes (automatically)

От: Thomas Güttler
Тема: Detect missing combined indexes (automatically)
Дата: ,
Msg-id: fdbf5d62-c06a-761e-276e-ef72e772ed25@thomas-guettler.de
(см: обсуждение, исходный текст)
Ответы: Re: Detect missing combined indexes (automatically)  (Jim Finnerty)
Re: Detect missing combined indexes (automatically)  (Thomas Kellerer)
Список: pgsql-performance

Скрыть дерево обсуждения

Detect missing combined indexes (automatically)  (Thomas Güttler, )
 Re: Detect missing combined indexes (automatically)  (Jim Finnerty, )
 Re: Detect missing combined indexes (automatically)  (Thomas Kellerer, )
  Re: Detect missing combined indexes (automatically)  (Julien Rouhaud, )
   Re: Detect missing combined indexes (automatically)  (Thomas Güttler, )
    Re: Detect missing combined indexes (automatically)  (Julien Rouhaud, )

Is there a way to detect missing combined indexes automatically

I am managing a lot of databases and I think a lot of performance
could get gained.

But I don't want to do this manually.

My focus is on missing combined indexes, since for missing
single indexes there are already tools available.

Regards,
   Thomas Güttler


-- 
Thomas Guettler http://www.thomas-guettler.de/
I am looking for feedback: https://github.com/guettli/programming-guidelines



В списке pgsql-performance по дате сообщения:

От: Guillaume Lelarge
Дата:
Сообщение: Re: does dml operations load the blocks to the shared buffers ?
От: Jim Finnerty
Дата:
Сообщение: Re: Detect missing combined indexes (automatically)