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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers