| From: | Neto pr <netopr9(at)gmail(dot)com> |
|---|---|
| To: | Anthony Sotolongo <asotolongo(at)gmail(dot)com> |
| Cc: | postgres performance list <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Index-Advisor Tools |
| Date: | 2017-10-31 17:25:55 |
| Message-ID: | CA+wPC0OXyPoQ0L38r8-9Gndf4QkwZOvmKn33d3ZmG4=FPfqRMQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)gmail(dot)com>:
> Hi Neto, maybe HypoPG
> Can help you:
>
> https://github.com/dalibo/hypopg
>
> El 31 oct. 2017 2:13 PM, "Neto pr" <netopr9(at)gmail(dot)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_Postgre
>> s_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
>>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alexandre de Arruda Paes | 2017-10-31 19:25:36 | Re: Index-Advisor Tools |
| Previous Message | Anthony Sotolongo | 2017-10-31 17:19:58 | Re: Index-Advisor Tools |