Postgres Pro
Downloads
Home   >   mailing lists

Re: PostgreSQL 12.3 slow index scan chosen - Mailing list pgsql-performance

From Tom Lane
Subject Re: PostgreSQL 12.3 slow index scan chosen
Date
Msg-id 1760785.1592605845@sss.pgh.pa.us
Whole thread Raw
In response to Re: PostgreSQL 12.3 slow index scan chosen  (Kenneth Marshall <ktm@rice.edu>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: Kenneth Marshall
Date:
Subject: Re: PostgreSQL 12.3 slow index scan chosen
Next
From: Kenneth Marshall
Date:
Subject: Re: PostgreSQL 12.3 slow index scan chosen