public inbox for [email protected]
help / color / mirror / Atom feedALTER INDEX .. SET STATISTICS not documented
2+ messages / 2 participants
[nested] [flat]
* ALTER INDEX .. SET STATISTICS not documented
@ 2015-07-16 14:31 Alvaro Herrera <[email protected]>
0 siblings, 1 reply; 2+ messages in thread
From: Alvaro Herrera @ 2015-07-16 14:31 UTC (permalink / raw)
To: pgsql-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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: ALTER INDEX .. SET STATISTICS not documented
@ 2015-07-16 14:44 Tom Lane <[email protected]>
parent: Alvaro Herrera <[email protected]>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2015-07-16 14:44 UTC (permalink / raw)
To: Alvaro Herrera <[email protected]>; +Cc: pgsql-docs
Alvaro Herrera <[email protected]> writes:
> 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?
Hm ... at one time there was not any real expectation that the ALTER INDEX
reference page would tell you exactly which subforms of ALTER TABLE would
work on an index; it was mostly "try it and see". But now we probably
should try to cover all the cases there, including this one.
regards, tom lane
--
Sent via pgsql-docs mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2015-07-16 14:44 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2015-07-16 14:31 ALTER INDEX .. SET STATISTICS not documented Alvaro Herrera <[email protected]>
2015-07-16 14:44 ` Tom Lane <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox