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: 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: Fri, 05 Oct 2007 12:39:41 +0200
  • Message-id: <4706146D(dot)8010108(at)lelarge(dot)info>

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



Home | Main Index | Thread Index

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