Quick Links

Creating indexes in the background

From:	David Lee <davidomundo(at)gmail(dot)com>
To:	"pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject:	Creating indexes in the background
Date:	2012-10-27 23:20:46
Message-ID:	D6D7E76B-C5F9-4EB4-963B-591928190865@gmail.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-hackers

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?

--David

Responses

Re: Creating indexes in the background at 2012-10-28 14:48:24 from David Johnston
Re: Creating indexes in the background at 2012-10-28 19:08:54 from Jeff Janes
Re: Creating indexes in the background at 2012-10-28 20:19:18 from Jaime Casanova
Re: Creating indexes in the background at 2012-10-28 23:48:56 from Michael Paquier
Re: Creating indexes in the background at 2012-10-29 12:00:22 from Robert Haas
Re: Creating indexes in the background at 2012-10-29 13:29:50 from Simon Riggs

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Hannu Krosing	2012-10-28 09:43:52	Should "select 'nan'::float = 'nan'::float;" return false as per IEEE 754
Previous Message	Greg Sabino Mullane	2012-10-27 23:15:14	Re: My first patch! (to \df output)