Hi, I'ver been wondering how to set the number of rows that are scanned by analyze. (I want to increase it) I couln't find it at first but when i read closer i found that is does: "The largest statistics target among the columns being analyzed determines the number of table rows sampled to prepare the statistics." (http://www.postgresql.org/docs/8.4/interactive/sql-analyze.html) My question is *HOW* does it "detirmine the number of table rows sampled" with the statistics target? What is the formula behind it? I am not familiar enough with the source code to figure that out myself. sry about that. Would be good to include in the docs if we find out. Cheers, WBL -- "Patriotism is the conviction that your country is superior to all others because you were born in it." -- George Bernard Shaw -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
