PFC wrote:
> On Thu, 31 May 2007 22:20:09 +0200, Vivek Khera <vivek@khera.org> 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 <bruce@momjian.us> http://momjian.us
EnterpriseDB http://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +