Re: PostgreSQL 12.3 slow index scan chosen

Kenneth Marshall <ktm@rice.edu> writes:
> On Fri, Jun 19, 2020 at 06:10:34PM -0400, Tom Lane wrote:
>> Hmm, does seem like you have some outlier keys.  Are any of the keys in
>> the column you're trying to join to larger than 27667772?

> The only values above 27667772? for objectid are:

Sorry, I meant the other join column, ie articles.id.

            regards, tom lane