On Thu, Oct 31, 2013 at 10:59 AM, Tom Lane <t...@sss.pgh.pa.us> wrote: > However, if the index is unique, wouldn't > scanning the index produce data that actually satisfies the longer sort > key? It doesn't matter what the values of c,d are if there are no > duplicates in the a,b columns. So maybe as a separate patch, we could > look at claiming that a unique index satisfies the entire query_pathkeys > if it matches the first N columns of that.
That would be really spiffy. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
