VACUUM on multi-CPU systems?

Поиск
Список
Период
Сортировка
От Jeff Boes
Тема VACUUM on multi-CPU systems?
Дата
Msg-id akdjh0$j5b$1@news.hub.org
обсуждение исходный текст
Список 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

В списке pgsql-admin по дате отправления:

Предыдущее
От: Elielson Fontanezi
Дата:
Сообщение: MSAcess databasse type X PostgreSQL database type
Следующее
От: Andrew Sullivan
Дата:
Сообщение: Re: Partial digest for the pgsql-admin list