Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

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: Fri, 05 Oct 2007 13:55:37 +0100
  • Message-id: <47063449(dot)80808(at)postgresql(dot)org>

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



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group