order of operations for pg_restore

Поиск
Список
Период
Сортировка
От Andrew Hammond
Тема order of operations for pg_restore
Дата
Msg-id CAAC-ZNX-3smZab_sqNriObTVEVO41K0eW_5wqj3SSKkh755gdQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: order of operations for pg_restore  (Andrew Dunstan <andrew@dunslane.net>)
Список pgsql-hackers
I'm working on a tool that runs pg_restore with -j 4. I notice that
after COPYing in the data, pg_restore does two indexes and a cluster
command in parallel. The first CREATE INDEX is running, the CLUSTER
command is waiting on it and the second CREATE INDEX is waiting on the
CLUSTER. This seems sub-optimal. Would it make sense to run the
CLUSTER command first? I'm pretty sure I can replicate the behavior if
necessary. Running 9.1.2.

Andrew


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

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: Re: JSON for PG 9.2
Следующее
От: Tom Lane
Дата:
Сообщение: Re: WIP -- renaming implicit sequences