XML index

From: Chris Roffler <croffler(at)earthlink(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: XML index
Date: 2010-05-27 11:22:59
Message-ID: AANLkTilsjUkXXtGYzzLW57j6RNBqKXaMdDvvnffKj41v@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have a table with an xml column, created an index as follows:

*CREATE INDEX xml_index*
* ON test*
* USING btree*
* (((xpath('//*/ChangedBy/text()'::text, external_attributes))[1]::text));*

And here is my select statement:

*Select uuid from t *
* where (xpath('//*/ChangedBy/text()', external_attributes))[1]::text =
'User';*
*
*
I then insert 100rows into this table, then do a select with the above
statement.
*Explain *shows that the query is using the xml_index.

Now I insert 5000 more rows and *Explain *shows that the query does not use
the xml_index anymore.
However, if I drop the index and re create it, then *Explain *tells me that
it's using the index again.

Any ideas what is going on here ?

Thanks
Chris
*
*

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thom Brown 2010-05-27 11:53:57 Re: XML index
Previous Message Davor J. 2010-05-27 10:36:12 conditional rules VS 1 unconditional rule with multiple commands?