Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id 957B97E4443 for ; Fri, 22 Jun 2012 14:08:14 -0300 (ADT) Received: from vexbert.mr-paradox.net ([2001:470:b:28:f::1]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Si7L9-0000NX-70 for pgsql-performance@postgresql.org; Fri, 22 Jun 2012 17:08:13 +0000 Received: by vexbert.mr-paradox.net (Postfix, from userid 18391) id 1710E84640; Fri, 22 Jun 2012 13:07:56 -0400 (EDT) Date: Fri, 22 Jun 2012 10:07:56 -0700 From: David Kerr To: pgsql-performance@postgresql.org Subject: Drop statistics? Message-ID: <20120622170755.GB93663@mr-paradox.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.4.2.3i X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201206/118 X-Sequence-Number: 47144 I'm trying to work through a root cause on a performance problem. I'd like to be able to "show" that a problem was fixed by analyzing the table. what i've done is set default_statistics_target=1 analyze That gets rid of most of the rows in pg_stats, but i'm still getting decent performance. It's possible that the existing stats were just not optimal, and i won't be able to get that back. But I just want to verify that what i've done is the only real option that I have? am i missing anything else that I could try? (I'm on PG9.1) Thanks. Dave