Re: Concurrent connections in psql

Tom Lane wrote:
> "Simon Riggs" <simon@2ndquadrant.com> writes:
>> I would love, love, love to be able to use this syntax within pg_dump as
>> well, so we can create multiple indexes in parallel at restore time.
> 
> I can hardly conceive of greater folly than putting an *experimental*
> psql facility into pg_dump scripts, thereby forcing us to support it
> until the end of time.

We could write a [awk | perl | scripting language of your choice]-script  to transform CREATE INDEX statements in
normalpg_dump output to use 
 
the concurrent psql commands. That way we don't need to modify pg_dump. 
Whether or not to build indexes should be a restore-time, not dump-time 
option anyway. Whether you want it or not it depends on the target, not 
the source.

--   Heikki Linnakangas  EnterpriseDB   http://www.enterprisedb.com