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