Andrew Dunstan wrote:
> > Wasn't that a big part of the point of the "parallel pg_restore" feature?
> >
> >
>
> Well, yes, it's some of it, and in theory Tom's late addition of a queue
> that gets all the dependencies of a table as soon as the table data is
> restored should make that work better. But of course, that's not the
> only time indexes are created, and each index creation command will be
> doing its own heap processing, albeit that synchronised scanning will
> make that lots cheaper.
>
> As I said originally, it was just an idle thought that came to me today.
Well, TODO has:
Allow multiple indexes to be created concurrently, ideally via asingle 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.
-- Bruce Momjian <bruce@momjian.us> http://momjian.us EnterpriseDB
http://enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +