Re: [HACKERS] non-blocking CREATE INDEX in 8.2??
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 ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [HACKERS] non-blocking CREATE INDEX in 8.2??
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 ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re: [HACKERS] non-blocking CREATE INDEX in 8.2??
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 [EMAIL PROTECTED] EnterpriseDB http://enterprisedb.com 512.569.9461 (cell) pgpOpzG4z9Zs9.pgp Description: PGP signature
Re: [HACKERS] non-blocking CREATE INDEX in 8.2??
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 ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
Re: [HACKERS] 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/ ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
[HACKERS] non-blocking CREATE INDEX in 8.2??
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_Matrix&oldid=1734 is the version where that was added (very early in the history of the page). -- Jim Nasby [EMAIL PROTECTED] EnterpriseDB http://enterprisedb.com 512.569.9461 (cell) pgpbHQz24XMTQ.pgp Description: PGP signature