On Tue, Oct 31, 2017 at 8:06 PM Julien Rouhaud wrote:
> On Tue, Oct 31, 2017 at 8:25 PM, Alexandre de Arruda Paes
> wrote:
> > 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).
>
As a vendor, I normally stay silent
On Tue, Oct 31, 2017 at 8:25 PM, Alexandre de Arruda Paes
wrote:
> 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)
I have not used it yet, but from the presentation, very promising:
https://medium.com/@ankane/introducing-dexter-the-automatic-indexer-for-postgres-5f8fa8b28f27
https://github.com/ankane/dexter
--
https://yves.zioup.com
gpg: 4096R/32B0F416
--
Sent via pgsql-performance mailing list (pgsql
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 part
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
20
Hi Neto, maybe HypoPG
Can help you:
https://github.com/dalibo/hypopg
El 31 oct. 2017 2:13 PM, "Neto pr" 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_
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
