Re: [HACKERS] non-blocking CREATE INDEX in 8.2??

2007-07-14 Thread Stefan Kaltenbrunner
Jim C. Nasby wrote: On Fri, Jul 13, 2007 at 01:45:18PM -0700, Joshua D. Drake wrote: Jim C. Nasby wrote: According to http://developer.postgresql.org/index.php/Feature_Matrix, 8.2 has non-blocking CREATE INDEX, which is news to me. Is it correct? CREATE INDEX CONCURRENTLY Well, I guess

Re: [HACKERS] non-blocking CREATE INDEX in 8.2??

2007-07-14 Thread Guillaume Lelarge
Jim C. Nasby a écrit : On Fri, Jul 13, 2007 at 01:45:18PM -0700, Joshua D. Drake wrote: Jim C. Nasby wrote: According to http://developer.postgresql.org/index.php/Feature_Matrix, 8.2 has non-blocking CREATE INDEX, which is news to me. Is it correct? CREATE INDEX CONCURRENTLY Well, I guess

[HACKERS] non-blocking CREATE INDEX in 8.2??

2007-07-13 Thread Jim C. Nasby
According to http://developer.postgresql.org/index.php/Feature_Matrix, 8.2 has non-blocking CREATE INDEX, which is news to me. Is it correct? http://developer.postgresql.org/index.php?title=Feature_Matrixoldid=1734 is the version where that was added (very early in the history of the page). --

Re: [HACKERS] non-blocking CREATE INDEX in 8.2??

2007-07-13 Thread Neil Conway
On Fri, 2007-07-13 at 15:38 -0500, Jim C. Nasby wrote: According to http://developer.postgresql.org/index.php/Feature_Matrix, 8.2 has non-blocking CREATE INDEX, which is news to me. Is it correct? http://www.postgresql.org/docs/8.2/static/sql-createindex.html See the CONCURRENTLY clause.

Re: [HACKERS] non-blocking CREATE INDEX in 8.2??

2007-07-13 Thread Joshua D. Drake
Jim C. Nasby wrote: According to http://developer.postgresql.org/index.php/Feature_Matrix, 8.2 has non-blocking CREATE INDEX, which is news to me. Is it correct? CREATE INDEX CONCURRENTLY :) Joshua D. Drake http://developer.postgresql.org/index.php?title=Feature_Matrixoldid=1734 is the

Re: [HACKERS] non-blocking CREATE INDEX in 8.2??

2007-07-13 Thread Jim C. Nasby
On Fri, Jul 13, 2007 at 01:45:18PM -0700, Joshua D. Drake wrote: Jim C. Nasby wrote: According to http://developer.postgresql.org/index.php/Feature_Matrix, 8.2 has non-blocking CREATE INDEX, which is news to me. Is it correct? CREATE INDEX CONCURRENTLY Well, I guess it's a good thing