Re: VACUUM on multi-CPU systems?

On Mon, 26 Aug 2002 12:04:23 -0400, Jeff Boes wrote:

> 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?

I didn't see any response to this, so I'll try just one more time and
then shut up ...

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