[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