Added to TODO: * Allow multiple indexes to be created concurrently, ideally via a single heap scan, and have a restore of a pg_dump somehow use it
http://archives.postgresql.org/pgsql-general/2007-05/msg01274.php --------------------------------------------------------------------------- Ron Johnson wrote: > On 06/01/07 11:22, Bruce Momjian wrote: > > 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. > > Or would a "CREATE MANY INDEXES" (where in one statement you specify > all the indexes on a single table) command be easier to implement? > > This way also the process reads the table once, building separate > sortwork files on-the-fly. Too bad child processes can't inherit > transaction state. > > -- > Ron Johnson, Jr. > Jefferson LA USA > > Give a man a fish, and he eats for a day. > Hit him with a fish, and he goes away for good! > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Have you searched our list archives? > > http://archives.postgresql.org/ -- 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 4: Have you searched our list archives? http://archives.postgresql.org/
