Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id DF1C59FC204 for ; Fri, 13 Jul 2007 13:53:42 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 68953-03 for ; Fri, 13 Jul 2007 13:53:31 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from kuber.nabble.com (kuber.nabble.com [216.139.236.158]) by postgresql.org (Postfix) with ESMTP id 73B0A9FB6FB for ; Fri, 13 Jul 2007 13:53:37 -0300 (ADT) Received: from isper.nabble.com ([192.168.236.156]) by kuber.nabble.com with esmtp (Exim 4.63) (envelope-from ) id 1I9OOX-0007xF-EC for pgsql-performance@postgresql.org; Fri, 13 Jul 2007 09:53:29 -0700 Message-ID: <11583450.post@talk.nabble.com> Date: Fri, 13 Jul 2007 09:53:29 -0700 (PDT) From: smiley2211 To: pgsql-performance@postgresql.org Subject: Database Statistics??? MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Nabble-From: smiley2211@yahoo.com X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.933 tagged_above=0 required=5 tests=AWL=-0.394, BAYES_00=-2.599, DNS_FROM_OPENWHOIS=1.13, FORGED_YAHOO_RCVD=2.297, WHOIS_MYPRIVREG=1.499 X-Spam-Level: * X-Archive-Number: 200707/157 X-Sequence-Number: 25841 Hello all, I am a bit confused...I have a database which was performing very POORLY selecting from a view (posted earlier) on one server but extremely fast on another server... I just backed up the database from the FAST server and loaded to the SLOW server and it ran just as fast as it originally did...my questions are: Are STATISTICS some how saved with the database?? if so, how do I UPDATE view or update them? Should I backup the data \ drop the database and reload it to make it get new stats?? (vacuum analyze does nothing for this poor performing database) Thanks-a-bunch. -- View this message in context: http://www.nabble.com/Database-Statistics----tf4075655.html#a11583450 Sent from the PostgreSQL - performance mailing list archive at Nabble.com.