Re: CREATE INDEX CONCURRENTLY

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc: pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org>
Subject: Re: CREATE INDEX CONCURRENTLY
Date: 2007-10-05 10:39:41
Message-ID: 4706146D.8010108@lelarge.info
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

Simon Riggs a écrit :
> It would be great if there was a database-level option so that any new
> indexes would default to using CONCURRENTLY.
>
> This would allow production systems to be changed easily using the
> default of CONCURRENTLY, whereas dev systems won't need that.
>
> If not, can we just have a general default of use concurrent builds?
>

I would be in favor of a database level option. It would be an
interesting feature for next release. If Dave is OK with this, I will
add this on our todo page.

> Got a crash on Beta5 yesterday while creating indexes, not been able to
> reproduce it. Sorry.
>

beta5 crashes at the creation of a pkey. It's already fixed on SVN.

--
Guillaume.
http://www.postgresqlfr.org
http://dalibo.com

In response to

Responses

Browse pgadmin-hackers by date

  From Date Subject
Next Message svn 2007-10-05 11:09:09 SVN Commit by guillaume: r6715 - trunk/pgadmin3/pgadmin/dlg
Previous Message svn 2007-10-05 10:22:44 SVN Commit by guillaume: r6714 - trunk/pgadmin3/pgadmin/schema