Re: [HACKERS] order of operations for pg_restore

2012-01-11 Thread Andrew Dunstan
On 01/11/2012 07:57 PM, Andrew Hammond wrote: 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 CREA

[HACKERS] order of operations for pg_restore

2012-01-11 Thread Andrew Hammond
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