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? Got a crash on Beta5 yesterday while creating indexes, not been able to reproduce it. Sorry. -- Simon Riggs 2ndQuadrant http://www.2ndQuadrant.com ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
