"Alvaro Herrera" <alvherre@xxxxxxxxxxxxxxxxx> 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
