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

Поиск
Список
Период
Сортировка
От Greg Stark
Тема Re: more than one index in a single heap pass?
Дата
Msg-id 407d949e0907141604m30309312ua7e805a085c5d84c@mail.gmail.com
обсуждение исходный текст
Ответ на Re: more than one index in a single heap pass?  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: more than one index in a single heap pass?  (Andrew Dunstan <andrew@dunslane.net>)
Список pgsql-hackers
On Tue, Jul 14, 2009 at 8:50 PM, Tom Lane<tgl@sss.pgh.pa.us> wrote:
> Alvaro Herrera <alvherre@commandprompt.com> writes:
>> Andrew Dunstan wrote:
>>> I was just wondering idly today if we could usefully build a number of
>>> indexes at the same time in a single pass over the heap, or could it be
>>> that we wouldn't gain much? I haven't even got around to thinking about
>>> any syntax for it.
>
>> Could we make it work on two backends building one index each in
>> synchronized scans?
>
> Don't we more or less have that already?

Wasn't that a big part of the point of the "parallel pg_restore" feature?

-- 
greg
http://mit.edu/~gsstark/resume.pdf


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Richard Huxton
Дата:
Сообщение: Re: navigation menu for documents
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: navigation menu for documents