Tom Lane wrote:
"Simon Riggs" <[EMAIL PROTECTED]> 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 normal pg_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

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Reply via email to