As a follow-up, when I try to create the index like this...
CREATE INDEX concurrently
idx_object_nodeid2
ON
object
USING
btree(
xpath('/a:root/a:Identification/b:ObjectId/text()', serialized_object,
ARRAY
[
ARRAY['a', 'http://schemas.datacontract.org/2004/07/Objects'],
ARRAY['b', 'http://schemas.datacontract.org/2004/07/Security']
])
) ;
The index begins to build but fails after about 90 seconds with this error:
ERROR: could not identify a comparison function for type xml
SQL state: 42883
Robert Haas wrote:
>
> On Thu, Sep 3, 2009 at 4:06 PM, astro77<astro_coder@yahoo.com> wrote:
>> I was receiving an error that an XML field does not support the various
>> indexes available in postgresql.
>
> Please post what happens when you try.
>
>> Is there an example of how to do this
>> properly?
>
> Not sure.
>
> ...Robert
>
> --
> Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance
>
>
--
View this message in context: http://www.nabble.com/Slow-select-times-on-select-with-xpath-tp25259351p25530455.html
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.