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
*
*
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? |