| 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: | Whole Thread | Raw Message | 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
*
*
| 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? |