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

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.


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

Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:

Reply via email to