New answers tagged


On my PostgreSQL (8.3) I use this trick: I get table's disk size using pg_total_relation_size() - this includes indexes and TOAST size, which is what VACUUM processes. This gives me the idea of how many bytes the VACUUM has to read. I run VACUUM on the table. I find the pid of the VACUUM process (in pg_catalog.pg_stat_activity). In Linux shell I run while ...

Top 50 recent answers are included