Pete Yunker <[email protected]> writes:
> Would a simple multi-column index be considered an 'expression' in this
> context, meaning that an ANALYZE should be issued after the creation of such
> an index?
No. Of course, if one of its columns were an expression, then that would
be of interest for ANALYZE.
There has been some talk of collecting column-correlation statistics for
sets of columns listed in multi-column indexes. So it's possible that in
some future PG version, creating a multi-column index will be a reason to
re-ANALYZE. But it isn't today.
regards, tom lane
--
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
