On 23 July 2015 at 19:59, Josh Berkus <j...@agliodbs.com> wrote: > 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. >
Agreed > 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. > Definitely not, though I think we should document a few things better here. I'll do that. -- Simon Riggs http://www.2ndQuadrant.com/ <http://www.2ndquadrant.com/> PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services