X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 8EBE3565CD for ; Fri, 11 Mar 2005 11:53:18 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 00783-03 for ; Fri, 11 Mar 2005 11:53:17 +0000 (GMT) Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.200]) by svr1.postgresql.org (Postfix) with ESMTP id 1AF78565B9 for ; Fri, 11 Mar 2005 11:53:16 +0000 (GMT) Received: by wproxy.gmail.com with SMTP id 70so921532wra for ; Fri, 11 Mar 2005 03:53:19 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:mime-version:content-type:content-transfer-encoding; b=LuORoPAjKNvy3CvBuxs4DvWqPhAjyWg007K1/AYnujN0iGVvGdVezNZwvwzGCfKItGlUWsycq16KeNIf6noiR1P9k3+u2beraQgcAQsuJpD9KRnTpotvnnHMqvZgpFpZfLnPpVNZh26rBMHP0ES2UddOpSf3EvgKFdxZKmyzrbc= Received: by 10.54.77.7 with SMTP id z7mr1268326wra; Fri, 11 Mar 2005 03:53:18 -0800 (PST) Received: by 10.54.18.9 with HTTP; Fri, 11 Mar 2005 03:53:18 -0800 (PST) Message-ID: <4e8efcf505031103531e49c8d0@mail.gmail.com> Date: Fri, 11 Mar 2005 11:53:18 +0000 From: Hugo Ferreira Reply-To: Hugo Ferreira To: pgsql-performance@postgresql.org Subject: Statistics not working?? Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.462 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200503/185 X-Sequence-Number: 10890 Hi there! I think I may have a problem with the statistics in my postgresql 8.0 running under Windowx XP. When I view both pg_stat_all_tables and pg_stat_all_indexes, all the numeric columns that should hold the statistics are 0 (zero). My configuration file has the following: stats_start_collector = true stats_command_string = true stats_reset_on_server_start = false Any tip? Thanks in advance, Hugo Ferreira -- GPG Fingerprint: B0D7 1249 447D F5BB 22C5 5B9B 078C 2615 504B 7B85