On 07/06/2015 12:20 AM, Marc Mamin wrote:
> There seems to be no "fence" against useless BRIN indexes that would allow a fallback on a table scan.
> But the time overhead remind small :)
When have we ever stopped users from creating useless indexes? For one
thing, just because the index isn't useful *now* doesn't mean it won't
be in the future.
Now, it would be useful to have a brin_index_effectiveness() function so
that DBAs could check for themselves whether they should dump indexes.
However, I don't see needing that for 9.5.
Are there usage stats in pg_stat_user_indexes for BRIN?
--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com