Re: Feature request for adoptive indexes - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Feature request for adoptive indexes
Date
Msg-id 178328.1635288336@sss.pgh.pa.us
Whole thread Raw
In response to Re: Feature request for adoptive indexes  (Mark Dilger <mark.dilger@enterprisedb.com>)
Responses Re: Feature request for adoptive indexes
List pgsql-hackers
Mark Dilger <mark.dilger@enterprisedb.com> writes:
> For three separate indexes, an update or delete of a single row in the indexed table would surely require changing at
leastthree pages in the indexes.  For some as-yet-ill-defined combined index type, perhaps the three entries in the
indexwould fall on the same index page often enough to reduce the I/O cost of the action? 

Of course, we have that today from the solution of one index with the
extra columns "included".  I think the OP has completely failed to make
any case why that's not a good enough approach.

            regards, tom lane



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Assorted improvements in pg_dump
Next
From: Joshua Brindle
Date:
Subject: [PATCH] Conflation of member/privs for predefined roles