PFC wrote: > On Thu, 31 May 2007 22:20:09 +0200, Vivek Khera <[EMAIL PROTECTED]> wrote: > > > > > On May 25, 2007, at 5:28 PM, Tom Lane wrote: > > > >> That's true at the level of DDL operations, but AFAIK we could > >> parallelize table-loading and index-creation steps pretty effectively > >> --- and that's where all the time goes. > > > > I would be happy with parallel builds of the indexes of a given table. > > That way you have just one scan of the whole table to build all its > > indexes. > > Will the synchronized seq scan patch be able to do this by issuing all > the CREATE INDEX commands at the same time from several different database > connections ?
No, but it could someday. -- Bruce Momjian <[EMAIL PROTECTED]> http://momjian.us EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
