Received: from maia.hub.org (unknown [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 200A2B5DE18 for ; Thu, 14 Jul 2011 12:40:06 -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 19228-05 for ; Thu, 14 Jul 2011 15:38:00 +0000 (UTC) Received: from mx1.hub.org (mx1.hub.org [200.46.208.106]) by mail.postgresql.org (Postfix) with ESMTP id 8B9F7B5DFCC for ; Thu, 14 Jul 2011 12:38:00 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from spinlock.commandprompt.com (host-215.commandprompt.net [207.173.203.215]) by mx1.hub.org (Postfix) with ESMTP id 9477227FDFDF for ; Thu, 14 Jul 2011 12:37:59 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by spinlock.commandprompt.com (Postfix) with ESMTP id C5142348048; Thu, 14 Jul 2011 08:37:36 -0700 (PDT) X-Virus-Scanned: Debian amavisd-new at commandprompt.com Received: from spinlock.commandprompt.com ([127.0.0.1]) by localhost (spinlock.commandprompt.com.commandprompt.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 5wR-L2aR-tF9; Thu, 14 Jul 2011 08:37:32 -0700 (PDT) Received: from perhan.alvh.no-ip.org (unknown [190.95.11.98]) by spinlock.commandprompt.com (Postfix) with ESMTPSA id E26A8348046; Thu, 14 Jul 2011 08:37:31 -0700 (PDT) Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000) id EB5926E307; Thu, 14 Jul 2011 11:37:28 -0400 (CLT) Content-Type: text/plain; charset=UTF-8 Cc: Pg Docs Subject: Re: pg_stat_database not in the index 9.0.4 From: Alvaro Herrera To: Emanuel Calvo In-reply-to: References: Date: Thu, 14 Jul 2011 11:37:28 -0400 Message-Id: <1310657596-sup-6756@alvh.no-ip.org> User-Agent: Sup/git Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.899 tagged_above=-5 required=5 tests=BAYES_00=-1.9, NO_DNS_FOR_FROM=0.001, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201107/12 X-Sequence-Number: 6879 Excerpts from Emanuel Calvo's message of lun jul 11 15:59:44 -0400 2011: > I realized that the view pg_stat_database is not in the book index: > > http://www.postgresql.org/docs/9.0/static/bookindex.html > > Maybe it must point to: > http://www.postgresql.org/docs/9.0/static/monitoring-stats.html Hmm, yeah, it seems all those entries got indexed only recently (Oct 2010), but whoever did it didn't backpatch it to 9.0. See commit e8a47b3cb92de64e80ae444e90f5a9cbb4294d48 -- Álvaro Herrera The PostgreSQL Company - Command Prompt, Inc. PostgreSQL Replication, Consulting, Custom Development, 24x7 support