Re: Creating indexes in the background

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: Creating indexes in the background
Дата
Msg-id CAMkU=1wZEwYqnnNUbnYaiVRsx65Vq-k0uFn7ESQksoWEAQwO-w@mail.gmail.com
обсуждение исходный текст
Ответ на Creating indexes in the background  (David Lee <davidomundo@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: nadeesh t v
Дата:
Сообщение: Index creation in postgresql
Следующее
От: Robert Haas
Дата:
Сообщение: Re: Creating indexes in the background