Re: Creating multiple indexes in one table scan. - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: Creating multiple indexes in one table scan.
Date
Msg-id 4FBE7961.8050105@dunslane.net
Whole thread Raw
In response to Re: Creating multiple indexes in one table scan.  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers

On 05/24/2012 11:44 AM, Robert Haas wrote:
> On Thu, May 24, 2012 at 11:25 AM, Gurjeet Singh<singh.gurjeet@gmail.com>  wrote:
>> It'd be great if one of standard utilities like pg_restore supported this,
>> by spawning every concurrent index build in separate backends. Just a
>> thought.
> If parallel restore doesn't already take this into account when doing
> job scheduling, that would be a worthwhile improvement to consider.
>
>


Parallel restore allows it in some cases, but not in others. You can't 
create an index-backed constraint concurrently with any other index 
because ALTER TABLE takes an ACCESS EXCLUSIVE lock.

We could get around that changing pg_dump to create the index first and 
then add the constraint using the existing index.

cheers

andrew





pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: plperl_helpers.h fix for clang
Next
From: Josh Berkus
Date:
Subject: Re: Changing the concept of a DATABASE