| From: | "Magnus Hagander" <mha(at)sollentuna(dot)net> |
|---|---|
| To: | "Bruce Momjian" <bruce(at)momjian(dot)us>, "PostgreSQL-development" <pgsql-hackers(at)postgreSQL(dot)org>, "PostgreSQL-documentation" <pgsql-docs(at)postgreSQL(dot)org> |
| Cc: | "Peter Eisentraut" <peter_e(at)gmx(dot)net> |
| Subject: | Re: New XML section for documentation |
| Date: | 2006-08-26 05:19:38 |
| Message-ID: | 6BCB9D8A16AC4241919521715F4D8BCEA0FB72@algol.sollentuna.se |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs pgsql-hackers |
> 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).
//Magnus
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2006-08-26 06:08:12 | Re: New XML section for documentation |
| Previous Message | Bruce Momjian | 2006-08-26 03:35:40 | Re: VALUES clause memory optimization |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2006-08-26 06:08:12 | Re: New XML section for documentation |
| Previous Message | Bruce Momjian | 2006-08-26 03:46:49 | Re: Coding style for emacs |