Re: Covering Indexes - Mailing list pgsql-hackers

From Florian Weimer
Subject Re: Covering Indexes
Date
Msg-id 877gsns8zp.fsf@mid.deneb.enyo.de
Whole thread Raw
In response to Re: Covering Indexes  (Jeff Janes <jeff.janes@gmail.com>)
List pgsql-hackers
* Jeff Janes:

> I don't see the virtue of this in this case.  Since the index is not
> unique, why not just put the index on (a,b,c,d) and be done with it?

AFAICT, SQLite 4 encodes keys in a way that is not easily reversed
(although the encoding is injective, so it's reversible in principle).
Therefore, covered columns need to be listed separately, so they are
not subject to the key encoding.



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: plperl sigfpe reset can crash the server
Next
From: Amit kapila
Date:
Subject: Re: [WIP] Performance Improvement by reducing WAL for Update Operation