VACUUM on multi-CPU systems?

From: Jeff Boes <jboes(at)nexcerpt(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: VACUUM on multi-CPU systems?
Date: 2002-08-26 16:04:23
Message-ID: akdjh0$j5b$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Andrew Sullivan 2002-08-26 17:23:54 Re: Partial digest for the pgsql-admin list
Previous Message Tim Ellis 2002-08-26 15:45:19 Re: thanks for tedia2sql