Re: [RFC] Minmax indexes - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: [RFC] Minmax indexes
Date
Msg-id 51BF5B42.70200@agliodbs.com
Whole thread Raw
In response to [RFC] Minmax indexes  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-hackers
> So there isn't a "fall down" thing here. We expect the recently
> loaded/updated data to be scanned and that's OK.
> 
> Having the minmax index updated greedily is just adding extra work for
> fast diminishing returns. We can always add that later if really
> needed, but I doubt it will be needed - in just the same way as mat
> views aren't greedily updated.

Ok, in that case, can we add the patch without messing with the FSM
logic?  It'll work out-of-the-box for append-only tables, and that's a
pretty solid use case.

-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com



pgsql-hackers by date:

Previous
From: Sawada Masahiko
Date:
Subject: Re: Patch for fail-back without fresh backup
Next
From: Josh Berkus
Date:
Subject: Re: refresh materialized view concurrently