Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1ZFkCk-0004P2-7c for pgsql-docs@arkaria.postgresql.org; Thu, 16 Jul 2015 14:32:06 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1ZFkCj-0005m7-Lr for pgsql-docs@arkaria.postgresql.org; Thu, 16 Jul 2015 14:32:05 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1ZFkCj-0005m0-69 for pgsql-docs@postgresql.org; Thu, 16 Jul 2015 14:32:05 +0000 Received: from smtp-auth.no-ip.com ([8.23.224.61] helo=out.smtp-auth.no-ip.com) by makus.postgresql.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84) (envelope-from ) id 1ZFkCc-0007zD-Dy for pgsql-docs@postgresql.org; Thu, 16 Jul 2015 14:32:03 +0000 X-No-IP: alvh.no-ip.org@noip-smtp X-Report-Spam-To: abuse@no-ip.com Received: from alvin.alvh.no-ip.org (unknown [92.255.15.69]) (Authenticated sender: alvh.no-ip.org@noip-smtp) by smtp-auth.no-ip.com (Postfix) with ESMTPA id 91A554005B1 for ; Thu, 16 Jul 2015 07:31:51 -0700 (PDT) Received: by alvin.alvh.no-ip.org (Postfix, from userid 1000) id 7066CD09; Thu, 16 Jul 2015 18:31:49 +0400 (SAMT) Date: Thu, 16 Jul 2015 17:31:49 +0300 From: Alvaro Herrera To: Pg Docs Subject: ALTER INDEX .. SET STATISTICS not documented Message-ID: <20150716143149.GO2301@postgresql.org> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit User-Agent: Mutt/1.5.23 (2014-03-12) X-Pg-Spam-Score: -2.6 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-docs Precedence: bulk Sender: pgsql-docs-owner@postgresql.org I'm sitting in Alexey Ermakov's talk and he just said that the command in $SUBJECT is not documented ... do we need a separate blurb about it somewhere? I just tried it and it does do something useful, at least for expression indexes, since we collect stats for those. This is news to me. There's a small issue that the column names for them are rather awful, but since they are unique there's not actually anything you can't do. Note that it's allowed to change the stats target of non-expression index columns too, but that doesn't seem to have any useful effect. -- Álvaro Herrera Peñalolén, Chile -- Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs