Re: Regression: 8.3 2 seconds -> 8.4 100+ seconds - Mailing list pgsql-performance

From Francisco Reyes
Subject Re: Regression: 8.3 2 seconds -> 8.4 100+ seconds
Date
Msg-id cone.1288192445.213964.5695.1000@shelca
Whole thread Raw
In response to Regression: 8.3 2 seconds -> 8.4 100+ seconds  (Francisco Reyes <lists@stringsutils.com>)
List pgsql-performance
 [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

pgsql-performance by date:

Previous
From: Marcin Mirosław
Date:
Subject: Re: Regression: 8.3 2 seconds -> 8.4 100+ seconds
Next
From: Francisco Reyes
Date:
Subject: Re: Running 9 in production? Sticking with 8.4.4 for a while?