From: | astro77 <astro_coder(at)yahoo(dot)com> |
---|---|
To: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: Slow select times on select with xpath |
Date: | 2009-09-21 19:51:56 |
Message-ID: | 25530455.post@talk.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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(at)yahoo(dot)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(at)postgresql(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Haas | 2009-09-21 20:08:44 | Re: query memory consumption |
Previous Message | astro77 | 2009-09-21 19:13:29 | Re: Slow select times on select with xpath |