Ron Mayer <rm_pg@xxxxxxxxxxxxxxxxxxxxxxx> 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
