On 07/23/2015 11:18 AM, Robert Haas wrote: > Cool. I'm not sure exactly what the right solution is either, but it > seems like the current situation could very well lead to degrading > index performance over time, with no way to put that right except to > rebuild the index completely. So it seems worth trying to improve > things.
As a reality check, if that was the situation, it wouldn't be the only type of index to have that problem. Even our BTrees, with certain update patterns, need to be periodically rebuilt from scratch. In other words, I don't think that fixing performance issues with BRIN indexes and frequenly-updated tables should be a blocker for 9.5. Not clear on whether we're considering this an open item or not. -- 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