Alex <[EMAIL PROTECTED]> writes:
There won't be anything to VACUUM after the insert, but perhaps you still want to run ANALYZE. Note that a plain ANALYZE uses a statistical sample which is much faster, whereas VACUUM ANALYZE has to look at every record anyways so it's slower but produces more accurate statistics. If you don't have
That is not true. My nightly vacuum analyze clearly is sampling:
INFO: "tablename": 22102 pages, 30000 rows sampled, 1712934 estimated total rows
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
