public inbox for [email protected]  

help / color / mirror / Atom feed

From: Alvaro Herrera <[email protected]>
To: Pg Docs <[email protected]>
Subject: ALTER INDEX .. SET STATISTICS not documented
Date: Thu, 16 Jul 2015 17:31:49 +0300
Message-ID: <[email protected]> (raw)
List-Unsubscribe: <mailto:[email protected]?body=unsub%20pgsql-docs>

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 ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs

view thread (2+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected]
  Subject: Re: ALTER INDEX .. SET STATISTICS not documented
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox