> > ... I have seen many instances of when > > PostgreSQL refuses to use an index because the data distribution is uneven. > > This is fixed, or at least attacked, in 7.2. Again, I do not see > this as an argument for making the planner stupider instead of > smarter.
Could someone fork out some decent criteria for these "stats" that way someone could generate a small app that would recommend these values on a per site basis. Having them hardwired and stuffed into a system catalog does no good to the newbie DBA. Iterating over a set of SQL statements, measuring the output, and then sending the user the results in the form of recommended values would be huge. <dumb_question>Where could I look for an explanation of all of these values?</dumb_question> -sc -- Sean Chittenden ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
