Re: more than one index in a single heap pass? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: more than one index in a single heap pass?
Date
Msg-id 22494.1247669604@sss.pgh.pa.us
Whole thread Raw
In response to Re: more than one index in a single heap pass?  (Bruce Momjian <bruce@momjian.us>)
List pgsql-hackers
Bruce Momjian <bruce@momjian.us> writes:
> Well, TODO has:

>     Allow multiple indexes to be created concurrently, ideally via a
>     single heap scan, and have pg_restore use it

>         Isn't this already largely done by parallel pg_restore work? 

> so we have to decide if we still want that item.  I think what we don't
> have is a way to create multiple indexes simultaneously via SQL.

And if we did build that, people would be bleating because it could only
make use of one CPU.  I think multiple backends using the existing
syncscan infrastructure meets this need pretty well already.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: more than one index in a single heap pass?
Next
From: David Blewett
Date:
Subject: Add encoding support to COPY