PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.
CREATE STATISTICS can collection statistics on the most common value, which can improve optimizations for columns that contain nonuniform distributions.