David Steele <david@pgmasters.net> writes:
> On 2/26/15 5:23 PM, Alvaro Herrera wrote:
>> It isn't. It also doesn't create any indexes, which you might want to
>> do before analyze.
> Is it necessary to create indexes before analyzing?
> I usually do, just to be safe, but I thought statistics were based
> solely on sampling of the heap.
ANALYZE pays no attention to plain indexes. If you have any expression
indexes, it will collect stats for those expressions.
regards, tom lane