Re: more than one index in a single heap pass?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: more than one index in a single heap pass?
Дата
Msg-id 22494.1247669604@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: more than one index in a single heap pass?  (Bruce Momjian <bruce@momjian.us>)
Список 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 по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: more than one index in a single heap pass?
Следующее
От: David Blewett
Дата:
Сообщение: Add encoding support to COPY