VACUUM on multi-CPU systems? - Mailing list pgsql-admin

Does anyone have any thoughts on whether my database vacuum/full/analyze
might go faster on our 2-CPU system if I generated the VACUUM commands
into a script, e.g.,

    psql -a <<EOF
\t
\o /tmp/db_maint.$$
select distinct on (relname) 'VACUUM FULL ANALYZE "' || relname || '";'
from pg_class
where relkind='r'
\g
\o
EOF

(generates a script that looks like

  VACUUM FULL ANALYZE table1;
  VACUUM FULL ANALYZE table2;

etc.)

and then started two psql sessions each processing half of the file?

--
Jeff Boes                                      vox 269.226.9550 ext 24
Database Engineer                                     fax 269.349.9076
Nexcerpt, Inc.                                 http://www.nexcerpt.com
           ...Nexcerpt... Extend your Expertise