Magnus Hagander wrote: > > Indexing > > -------- > > Because XML documents are stored as text, full-text indexing tool > > /contrib/tsearch2 can be used to index XML documents. Of > > course, the searches are text searches, with no XML > > awareness, but tsearch2 can be used with other XML > > capabilities to dramatically reduce the amount of data > > processed at the XML level. > > > You can also use a functional index and /contrib/xml2 to do limited > XPath indexing. (Can't make it "subtree-aware" for example, unless you > are willing to change your queries, but you can index specific xpath > nodes).
Good point, added. -- Bruce Momjian [EMAIL PROTECTED] EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
