Re: [PERFORM] Index-Advisor Tools
| От | Alexandre de Arruda Paes |
|---|---|
| Тема | Re: [PERFORM] Index-Advisor Tools |
| Дата | |
| Msg-id | CAGewt-uXrx3MKEFs6b77tVQe68hF2aW_BesodSNUG-aqNJuaUw@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: [PERFORM] Index-Advisor Tools (Neto pr <netopr9@gmail.com>) |
| Ответы |
Re: [PERFORM] Index-Advisor Tools
|
| Список | pgsql-performance |
I will be very happy with a tool(or a stats table) that shows the most searched values from a table(since a statistic reset). i.e.:
table foo (id int, year int)
top 3 searched value for year field: 2017(500x), 2016(300x), 2015(55x)
With this info we can create partial indexes or do a table partitioning.
2017-10-31 15:25 GMT-02:00 Neto pr <netopr9@gmail.com>:
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 RegardsNeto2017-10-31 15:19 GMT-02:00 Anthony Sotolongo <asotolongo@gmail.com>: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_Postgre s_Advanced_Server_Guide.1.56.h tml Someone would know of other tools for this purpose. I'd appreciate it if you can help me. Best RegardsNeto
В списке pgsql-performance по дате отправления: