Kenneth Marshall <ktm@xxxxxxxx> 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
