non-blocking CREATE INDEX in 8.2??

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_Matrix&oldid=1734
is the version where that was added (very early in the history of the
page).

--

=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/

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.

-Neil

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 someone created that cheat-sheet, 'cause
I can't keep which feature went into what version straight anymore. :)
--
Jim Nasby decibel@decibel.org
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)

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 it's a good thing someone created that cheat-sheet, 'cause
I can't keep which feature went into what version straight anymore. :)

glad that you like it :-) - but keep in mind that it clearly states that
this is page is still very much an experiment.
There is a lot of stuff still missing and it might as well contain a
number of inaccuracies too - so take everything there with a grain of
salt ...

Stefan

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 it's a good thing someone created that cheat-sheet, 'cause
I can't keep which feature went into what version straight anymore. :)

+1

I will try to add on my todo list to proofread and enhance this. Thanks
for this page, Stefan.

Regards.

--
Guillaume.
http://www.postgresqlfr.org
http://docs.postgresqlfr.org