[UTF-8]Marcin MirosÂaw writes:
W dniu 27.10.2010 16:53, Francisco Reyes pisze:
Pavel Stehule writes:
increase statistics on columns. The estimation is totally out.
Stats when I ran the above was at 250.
Will try 500.
Did 1000.
Please paste: ANALYZE VERBOSE argrades
analyze verbose argrades;
INFO: analyzing "public.argrades"
INFO: "argrades": scanned 75000 of 5122661 pages, containing 3054081 live
rows and 4152 dead rows; 75000 rows in sample, 208600288 estimated total rows
ANALYZE
--
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
