Re: Slow select times on select with xpath - Mailing list pgsql-performance

From astro77
Subject Re: Slow select times on select with xpath
Date
Msg-id 25530433.post@talk.nabble.com
Whole thread Raw
In response to Re: Slow select times on select with xpath  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-performance
CREATE INDEX CONCURRENTLY idx_serializedxml
   ON "object" (serialized_object ASC NULLS LAST);

yields the error:
ERROR: data type xml has no default operator class for access method "btree"

The same error occurs when I try to use the other access methods as well.


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.


--
View this message in context: http://www.nabble.com/Slow-select-times-on-select-with-xpath-tp25259351p25530433.html
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.


pgsql-performance by date:

Previous
From: Vincent de Phily
Date:
Subject: Re: slow query : very simple delete, 100% cpu, nearly no disk activity
Next
From: astro77
Date:
Subject: Re: Slow select times on select with xpath