Re: Creating indexes in the background - Mailing list pgsql-hackers

From Jeff Janes
Subject Re: Creating indexes in the background
Date
Msg-id CAMkU=1wZEwYqnnNUbnYaiVRsx65Vq-k0uFn7ESQksoWEAQwO-w@mail.gmail.com
Whole thread Raw
In response to Creating indexes in the background  (David Lee <davidomundo@gmail.com>)
List pgsql-hackers
On Sat, Oct 27, 2012 at 4:20 PM, David Lee <davidomundo@gmail.com> wrote:
> Hey folks,
>
> It seems like right now when you want to create an index concurrently, the index creation will get canceled if you
cancelthe statement (i.e. you must keep your statement open).
 
>
> Is there a way to "launch" an index creation in the background so that the statement doesn't need to be kept open?

Launch the session itself in the background.

For example, on linux:

psql -c 'create index concurrently ....' &

At some point, you will probably want to verify that the creation succeeded.

Cheers,

Jeff



pgsql-hackers by date:

Previous
From: nadeesh t v
Date:
Subject: Index creation in postgresql
Next
From: Robert Haas
Date:
Subject: Re: Creating indexes in the background