Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id C44921337B63 for ; Wed, 27 Oct 2010 12:14:13 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 82397-05 for ; Wed, 27 Oct 2010 15:14:06 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from manuel.natserv.net (p65-147.acedsl.com [66.114.65.147]) by mail.postgresql.org (Postfix) with ESMTP id 2C04A1337B5B for ; Wed, 27 Oct 2010 12:14:06 -0300 (ADT) Received: from shelca (zoraida.natserv.net [66.114.65.147]) by manuel.natserv.net (Postfix) with ESMTP id 50E92FA03; Wed, 27 Oct 2010 11:14:05 -0400 (EDT) References: <4CC83DAC.5000600@mejor.pl> Message-ID: X-Mailer: http://www.courier-mta.org/cone/ From: Francisco Reyes To: =?ISO-8859-1?B?W1VURi04XQ==?= Marcin =?ISO-8859-1?B?TWlyb3PFP2F3?= Cc: Pavel Stehule , Pgsql performance Subject: Re: Regression: 8.3 2 seconds -> 8.4 100+ seconds Date: Wed, 27 Oct 2010 11:14:05 -0400 Mime-Version: 1.0 Content-Type: text/plain; format=flowed; charset="ISO-8859-1" Content-Disposition: inline Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201010/472 X-Sequence-Number: 40890 [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