"Alvaro Herrera" <[EMAIL PROTECTED]> 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


---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Reply via email to