| From: | Jeff Janes <jeff(dot)janes(at)gmail(dot)com> |
|---|---|
| To: | David Lee <davidomundo(at)gmail(dot)com> |
| Cc: | "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Creating indexes in the background |
| Date: | 2012-10-28 19:08:54 |
| Message-ID: | CAMkU=1wZEwYqnnNUbnYaiVRsx65Vq-k0uFn7ESQksoWEAQwO-w@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Sat, Oct 27, 2012 at 4:20 PM, David Lee <davidomundo(at)gmail(dot)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 cancel the 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jaime Casanova | 2012-10-28 20:19:18 | Re: Creating indexes in the background |
| Previous Message | nadeesh t v | 2012-10-28 17:22:32 | Index creation in postgresql |