Tom Lane <t...@sss.pgh.pa.us> wrote: > I think we could go to > PG_CMD_PUTS("ANALYZE;\nVACUUM FULL FREEZE;\n"); > > without any degradation of the intended results. > > Another idea would be to drop the FULL part and make this > > PG_CMD_PUTS("ANALYZE;\nVACUUM FREEZE;\n");
We want to finish with VACUUM FREEZE without the FULL, unless we don't care about missing visibility maps and free space maps. [ initdb and start the cluster ] server started kgrittn@Kevin-Desktop:~/pg/master$ find Debug/data -type f | xargs ls -l >~/ls1 kgrittn@Kevin-Desktop:~/pg/master$ psql -c "vacuum freeze;" postgres VACUUM kgrittn@Kevin-Desktop:~/pg/master$ find Debug/data -type f | xargs ls -l >~/ls2 kgrittn@Kevin-Desktop:~/pg/master$ psql -c "vacuum full freeze;" postgres VACUUM kgrittn@Kevin-Desktop:~/pg/master$ find Debug/data -type f | xargs ls -l >~/ls3 kgrittn@Kevin-Desktop:~/pg/master$ grep _fsm <~/ls1 | wc -l 116 kgrittn@Kevin-Desktop:~/pg/master$ grep _fsm <~/ls2 | wc -l 119 kgrittn@Kevin-Desktop:~/pg/master$ grep _fsm <~/ls3 | wc -l 80 kgrittn@Kevin-Desktop:~/pg/master$ grep _vm <~/ls1 | wc -l 116 kgrittn@Kevin-Desktop:~/pg/master$ grep _vm <~/ls2 | wc -l 117 kgrittn@Kevin-Desktop:~/pg/master$ grep _vm <~/ls3 | wc -l 77 -- Kevin Grittner EDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers