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

From Greg Stark
Subject Re: more than one index in a single heap pass?
Date
Msg-id 407d949e0907141604m30309312ua7e805a085c5d84c@mail.gmail.com
Whole thread Raw
In response to Re: more than one index in a single heap pass?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: more than one index in a single heap pass?  (Andrew Dunstan <andrew@dunslane.net>)
List 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 by date:

Previous
From: Richard Huxton
Date:
Subject: Re: navigation menu for documents
Next
From: Andrew Dunstan
Date:
Subject: Re: navigation menu for documents