Re: [HACKERS] WARM and indirect indexes

On 01/10/2017 09:25 PM, Bruce Momjian wrote:
> I am not saying we shouldn't do it, but I am afraid that the complexity
> in figuring out when to use indirect indexes, combined with the number
> of users who will try them, really hurts its inclusion.
>


I think you're making this out to be far more complex than it really is. 
You could argue the same about a great many features. Both of these 
features have upsides and downsides.

Obviously we need to get some benchmarks to we can quantify the effects, 
but this complexity argument doesn't convince me at all. After all, 
nobody has to use indirect indexes.

-- 
Andrew Dunstan                https://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services