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

Reply via email to