Re: Indirect indexes

On 10/20/2016 06:39 AM, Alvaro Herrera wrote:
> Bruce Momjian wrote:

>> Also, it seems indirect indexes would be useful for indexing columns
>> that are not updated frequently on tables that are updated frequently,
>> and whose primary key is not updated frequently.  That's quite a logic
>> problem for users to understand.
>
> I don't think we should be optimizing only for dumb users.  In any case,
> updating primary key values is very rare; some would say it never
> happens.

Just because a person doesn't understand a use case doesn't make them dumb.

That said would it be possible to make this index an extension (like 
rum?). Assuming of course we can get any required infrastructure changes 
done in a general way.

I do think the feature has merit.

JD


-- 
Command Prompt, Inc.                  http://the.postgres.company/                        +1-503-667-4564
PostgreSQL Centered full stack support, consulting and development.
Everyone appreciates your honesty, until you are honest with them.