Hi,
Worked on something similar a few years back, have a look - it might give
you a few pointers :)
It's on similar lines to what you are looking at (I kept it updated up to
PG version 9.4/9.5)
https://github.com/cohenjo/pg_idx_advisor
My main focus was to add support for more index types: partial
Hi Yessica,
Postgres 8.3 is very old, If you are using that simply because of the index
advisor there are a few more “modern” options.
I at the time wrote such a tool for Postgres 9.4 (it has many features that the
one by Gurjeet didn’t have like CTE and partial indexes support)
Alas I didn’t ha
