Re: [PERFORM] Index-Advisor Tools

Поиск
Список
Период
Сортировка
От Neto pr
Тема Re: [PERFORM] Index-Advisor Tools
Дата
Msg-id CA+wPC0OXyPoQ0L38r8-9Gndf4QkwZOvmKn33d3ZmG4=FPfqRMQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [PERFORM] Index-Advisor Tools  (Anthony Sotolongo <asotolongo@gmail.com>)
Ответы Re: [PERFORM] Index-Advisor Tools
Список pgsql-performance
Дерево обсуждения
Thanks for reply Antony. 
But from what I've read, HYPOPG only allows you to create hypothetical indexes, so the DBA can analyze if it brings benefits.
What I would like is a tool that from a SQL Query indicates which indexes would be recommended to decrease the response time.

Best Regards
Neto

2017-10-31 15:19 GMT-02:00 Anthony Sotolongo <asotolongo@gmail.com>:
Hi Neto,  maybe 

HypoPG

Can help you:


El 31 oct. 2017 2:13 PM, "Neto pr" <netopr9@gmail.com> escribió:

Hello All I'm researching on Index-Advisor Tools to be applied in SQL queries. At first I found this: - EnterpriseDB - https://www.enterprisedb.com/docs/en/9.5/asguide/EDB_Postgres_Advanced_Server_Guide.1.56.html Someone would know of other tools for this purpose. I'd appreciate it if you can help me.

Best Regards
Neto

В списке pgsql-performance по дате отправления:

Предыдущее
От: Anthony Sotolongo
Дата:
Сообщение: Re: [PERFORM] Index-Advisor Tools
Следующее
От: Alexandre de Arruda Paes
Дата:
Сообщение: Re: [PERFORM] Index-Advisor Tools