From: Tom Lane <tgl@sss.pgh.pa.us>
To: Wells Oliver <wells.oliver@gmail.com>
cc: Craig James <cjames@emolecules.com>,
        pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: Query planning around one key of a multi-column index
In-reply-to: 
 <CAOC+FBWzn-TK99tZNP4s=HkFk1qWr6QXGnqDarLCKrBK5g_tXA@mail.gmail.com>
References: 
 <CAOC+FBWZKgW9d2613DLg8MPfYXaQ3KweXFV3MWawK43rJt=C8Q@mail.gmail.com>
 <CAFwQ8reu3kbbREr2M2i-7o7C-UdTOpMybRyMzbkcCwjhmiyMYQ@mail.gmail.com>
 <CAOC+FBWzn-TK99tZNP4s=HkFk1qWr6QXGnqDarLCKrBK5g_tXA@mail.gmail.com>
Comments: In-reply-to Wells Oliver <wells.oliver@gmail.com>
	message dated "Wed, 18 Dec 2019 20:18:46 -0800"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <18011.1576734429.1@sss.pgh.pa.us>
Date: Thu, 19 Dec 2019 00:47:09 -0500
Message-ID: <18012.1576734429@sss.pgh.pa.us>
Precedence: bulk

Wells Oliver <wells.oliver@gmail.com> writes:
> Is it really always true that querying off any column that's not the first
> column of a multi-column index will NOT use that index?

Nope.  The planner will consider that, though in most cases it's likely
to estimate that there's no benefit to using the index in such cases.
Try reading the *actual* docs, not some third-party site:

https://www.postgresql.org/docs/current/indexes-multicolumn.html

			regards, tom lane