I understand the negative implications with calling it "ONLINE" with regards to the index rebuild but I believe that would follow what the industry and professionals understand. Oracle denotes this concept as ONLINE and microsoft with it's new SQL Server 2005 markets the ability to do "ONLINE" reindexing. (rebuilding an index in SQL Server 2000 will cause blocking)
If I didn't know anything about PostgreSQL and read a manual about it's indexing capabilities and read that it had ONLINE reindexing, the first thing that I would think about was the ability to rebuild my indexes without causing any blocking or writers or readers. There might be a better token word to use in this situation but I don't think that ONLINE would be out of bounds... Just my 2 cents... Paul Silveira -- View this message in context: http://www.nabble.com/Better-name-syntax-for-%22online%22-index-creation-tf1992993.html#a5501425 Sent from the PostgreSQL - hackers forum at Nabble.com. ---------------------------(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