X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 9DECED1B89A for ; Fri, 5 Sep 2003 00:02:10 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 63007-07 for ; Thu, 4 Sep 2003 21:02:03 -0300 (ADT) Received: from mail.osdl.org (fw.osdl.org [65.172.181.6]) by svr1.postgresql.org (Postfix) with ESMTP id 11112D1B8A5 for ; Thu, 4 Sep 2003 21:01:59 -0300 (ADT) Received: from ibm-e.pdx.osdl.net (ibm-e.pdx.osdl.net [172.20.1.71]) by mail.osdl.org (8.11.6/8.11.6) with ESMTP id h8501uo32003; Thu, 4 Sep 2003 17:01:56 -0700 Subject: Re: [GENERAL] how to get accurate values in pg_statistic From: Mary Edie Meredith To: Neil Conway Cc: Rod Taylor , pgsql-performance , OSDL - DB General In-Reply-To: <1062719424.364.5.camel@tokyo> References: <1062697270.6854.3475.camel@ibm-e.pdx.osdl.net> <1062697606.88158.7.camel@jester> <1062719424.364.5.camel@tokyo> Content-Type: text/plain Organization: Open Source Development Lab Message-Id: <1062720115.6854.3662.camel@ibm-e.pdx.osdl.net> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.2.2 Date: 04 Sep 2003 17:01:56 -0700 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/81 X-Sequence-Number: 3447 The documentation lead us to believe that it would not, but we are testing just the same (at least checking that the pg_statistics are the same after each load and VACUUM FULL ANALYZE). Will report back. On Thu, 2003-09-04 at 16:50, Neil Conway wrote: > On Thu, 2003-09-04 at 13:46, Rod Taylor wrote: > > Run a VACUUM FULL ANALYZE between runs. This will force a full scan of > > all data for stats > > It will? Are you sure about that? > > -Neil > > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faqs/FAQ.html -- Mary Edie Meredith Open Source Development Lab