order of operations for pg_restore - Mailing list pgsql-hackers

From Andrew Hammond
Subject order of operations for pg_restore
Date
Msg-id CAAC-ZNX-3smZab_sqNriObTVEVO41K0eW_5wqj3SSKkh755gdQ@mail.gmail.com
Whole thread Raw
Responses Re: order of operations for pg_restore  (Andrew Dunstan <andrew@dunslane.net>)
List 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 by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: JSON for PG 9.2
Next
From: Tom Lane
Date:
Subject: Re: WIP -- renaming implicit sequences