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

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