Re: CREATE INDEX CONCURRENTLY

From: Dave Page <dpage(at)postgresql(dot)org>
To: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
Cc: Simon Riggs <simon(at)2ndquadrant(dot)com>, pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org>
Subject: Re: CREATE INDEX CONCURRENTLY
Date: 2007-10-05 12:55:37
Message-ID: 47063449.80808@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

Guillaume Lelarge wrote:
> 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.

We don't have any infrastructure for saving per-database settings. We
could have a general default easily enough though.

/D

In response to

Responses

Browse pgadmin-hackers by date

  From Date Subject
Next Message Simon Riggs 2007-10-05 13:05:31 Re: CREATE INDEX CONCURRENTLY
Previous Message svn 2007-10-05 11:09:09 SVN Commit by guillaume: r6715 - trunk/pgadmin3/pgadmin/dlg