pgsql: Avoid believing incomplete MCV-only stats in get_variable_range(

2021-10-01 Thread Tom Lane
Avoid believing incomplete MCV-only stats in get_variable_range(). get_variable_range() would incautiously believe that statistics containing only an MCV list are sufficient to derive a range estimate. That's okay for an enum-like column that contains only MCVs, but otherwise the estimate could be

pgsql: Avoid believing incomplete MCV-only stats in get_variable_range(

2021-10-01 Thread Tom Lane
Avoid believing incomplete MCV-only stats in get_variable_range(). get_variable_range() would incautiously believe that statistics containing only an MCV list are sufficient to derive a range estimate. That's okay for an enum-like column that contains only MCVs, but otherwise the estimate could be

pgsql: Avoid believing incomplete MCV-only stats in get_variable_range(

2021-10-01 Thread Tom Lane
Avoid believing incomplete MCV-only stats in get_variable_range(). get_variable_range() would incautiously believe that statistics containing only an MCV list are sufficient to derive a range estimate. That's okay for an enum-like column that contains only MCVs, but otherwise the estimate could be

pgsql: Avoid believing incomplete MCV-only stats in get_variable_range(

2021-10-01 Thread Tom Lane
Avoid believing incomplete MCV-only stats in get_variable_range(). get_variable_range() would incautiously believe that statistics containing only an MCV list are sufficient to derive a range estimate. That's okay for an enum-like column that contains only MCVs, but otherwise the estimate could be

pgsql: Avoid believing incomplete MCV-only stats in get_variable_range(

2021-10-01 Thread Tom Lane
Avoid believing incomplete MCV-only stats in get_variable_range(). get_variable_range() would incautiously believe that statistics containing only an MCV list are sufficient to derive a range estimate. That's okay for an enum-like column that contains only MCVs, but otherwise the estimate could be

pgsql: Avoid believing incomplete MCV-only stats in get_variable_range(

2021-10-01 Thread Tom Lane
Avoid believing incomplete MCV-only stats in get_variable_range(). get_variable_range() would incautiously believe that statistics containing only an MCV list are sufficient to derive a range estimate. That's okay for an enum-like column that contains only MCVs, but otherwise the estimate could be