Comments on: Hypothetical Indexes in PostgreSQL https://www.percona.com/blog/hypothetical-indexes-in-postgresql/ Tue, 02 Jul 2019 17:28:58 +0000 hourly 1 https://wordpress.org/?v=6.5.2 By: Julien Rouhaud https://www.percona.com/blog/hypothetical-indexes-in-postgresql/#comment-10970932 Fri, 28 Jun 2019 11:02:27 +0000 https://www.percona.com/blog/?p=57848#comment-10970932 Thanks for this article! Here are a few comments:

– the issue with BRIN hypothetical indexes is a actually regression introduced in pg10, I submitted a patch to fix that (https://commitfest.postgresql.org/23/2179/), I hope it’ll be fixed with the next minor release
– I’ll make it clearer in the documentation that multiple AM can be used with hypopg.
– about pg_qualstats and index suggestion, you can look at PoWA (https://powa.readthedocs.io/en/latest/), which has a decent global index suggestion feature, among other things. You can see it in action in the demo website, the “tpc” database is quite relevant for that.

]]>