Ron Mayer <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
