Re: Relation of indices to ANALYZE

Tom Lane wrote:
> Bill Moran <wmoran(at)potentialtech(dot)com> writes:
>
>>Specifically, I'm wondering if I should do
>>the ANALYZE before or after I recreate the indexes, or whether it matters.
>
>
> At the moment it does not matter --- ANALYZE computes statistics for
> each column of a table regardless of what indexes exist.
>
> There has been some talk of trying to compute statistics for the
> contents of functional indexes. Also, if we ever do anything about
> computing multicolumn correlation statistics, we'd likely choose which
> ones are worth computing based on the presence of multicolumn indexes.
> So if you want to future-proof your code I'd recommend recreating the
> indexes before you ANALYZE.

Thanks, Tom (and everyone else who replied).

I'm already recreating the indices prior to the VACUUM ANALYZE, since this
puts the database back in a more usable state faster than doing the
VACUUM first. It's good to know that it will probably be the proper way
to do things in the future as well.

--
Bill Moran
Potential Technologies
http://www.potentialtech.com