Re: Missed index opportunity for outer join?

Ron Mayer <rm_pg@cheapcomplexdevices.com> writes:
> Tom Lane wrote:
>> In this explanation, the reason for the change in plans over time could
>> be a change in the statistics for the other table.  Is "facets" more
>> dynamic than "point_features"?

> Facets is a big table with rather odd distributions of values.
> Many of the values in the indexed columns show up only
> once, others show up hundreds-of-thousands of times.  Perhaps
> an analyze ran and just randomly sampled differently creating
> different stats on that table?

If you have background tasks doing ANALYZEs then this explanation seems
plausible enough.  I'm willing to accept it anyway ...

            regards, tom lane