Kenneth Marshall <ktm@rice.edu> writes:
> On Fri, Jun 19, 2020 at 04:59:15PM -0400, Tom Lane wrote:
>> What's the actual maximum value of objectcustomfieldvalues.objectid,
>> and how does that compare to the endpoint value in the pg_stats
>> histogram for that column? If you've got one outlier in the table,
>> it might get missed by ANALYZE.
> max(objectcustomfieldvalues.objectid) = 28108423 and here is the
> histogram for that column:
... 3304313,3693956,27667772}
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?
regards, tom lane