Skip site navigation (1) Skip section navigation (2)

Re: Regression: 8.3 2 seconds -> 8.4 100+ seconds

From: Francisco Reyes <lists(at)stringsutils(dot)com>
To: [UTF-8] Marcin MirosÅ?aw <marcin(at)mejor(dot)pl>
Cc: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>, Pgsql performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Regression: 8.3 2 seconds -> 8.4 100+ seconds
Date: 2010-10-27 15:14:05
Message-ID: cone.1288192445.213964.5695.1000@shelca (view raw or flat)
Thread:
Lists: 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

In response to

pgsql-performance by date

Next:From: Francisco ReyesDate: 2010-10-27 15:19:43
Subject: Re: Running 9 in production? Sticking with 8.4.4 for a while?
Previous:From: Marcin MirosławDate: 2010-10-27 14:56:44
Subject: Re: Regression: 8.3 2 seconds -> 8.4 100+ seconds

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group