Postgres Pro
Downloads
Home   >   mailing lists

Creating indexes in the background - Mailing list pgsql-hackers

From David Lee
Subject Creating indexes in the background
Date
Msg-id D6D7E76B-C5F9-4EB4-963B-591928190865@gmail.com
Whole thread Raw
Responses Re: Creating indexes in the background  (David Johnston <polobo@yahoo.com>)
Re: Creating indexes in the background  (Jeff Janes <jeff.janes@gmail.com>)
Re: Creating indexes in the background  (Robert Haas <robertmhaas@gmail.com>)
Re: Creating indexes in the background  (Jaime Casanova <jaime@2ndquadrant.com>)
Re: Creating indexes in the background  (Michael Paquier <michael.paquier@gmail.com>)
Re: Creating indexes in the background  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-hackers
Tree view 
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?

--David

pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: proposal - assign result of query to psql variable
Next
From: Jan Wieck
Date:
Subject: Re: Logical to physical page mapping