*** pgsql/doc/src/sgml/perform.sgml 2007/12/28 21:03:31 1.68 --- pgsql/doc/src/sgml/perform.sgml 2008/12/13 19:13:43 1.69 *************** *** 1,4 **** ! Performance Tips --- 1,4 ---- ! Performance Tips *************** SELECT attname, n_distinct, most_common_ *** 562,568 **** column-by-column basis using the ALTER TABLE SET STATISTICS command, or globally by setting the configuration variable. ! The default limit is presently 10 entries. Raising the limit might allow more accurate planner estimates to be made, particularly for columns with irregular data distributions, at the price of consuming more space in pg_statistic and slightly more --- 562,568 ---- column-by-column basis using the ALTER TABLE SET STATISTICS command, or globally by setting the configuration variable. ! The default limit is presently 100 entries. Raising the limit might allow more accurate planner estimates to be made, particularly for columns with irregular data distributions, at the price of consuming more space in pg_statistic and slightly more