"Alvaro Herrera" <alvherre@commandprompt.com> writes:
> Steinar H. Gunderson wrote:
>
>> Shoot me if I'm wrong here, but doesn't VACUUM ANALYZE check _all_ tuples,
>> as compared to the random selection employed by ANALYZE?
>
> You are wrong, but it won't be me the one to shoot you.
>
> There have been noises towards making the ANALYZE portion use the same
> scan that VACUUM already does, but nobody has written the code (it would
> be useful for some kinds of stats).
I think it does for the count of total records in the table.
But not for the rest of the stats.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com