Changed the create index statement to : USING hash and it seems to work.
Any idea why btree does not work ?
Thanks
Chris
On Thu, May 27, 2010 at 3:47 PM, Chris Roffler <croff...@earthlink.net>wrote:
> Tried that .... same thing
>
>
> On Thu, May 27, 2010 at 1:53 PM, Thom Brown <thombr...@gmail.com> wrote:
>
>> On 27 May 2010 12:22, Chris Roffler <croff...@earthlink.net> wrote:
>> > 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
>> >
>>
>> I'd run an ANALYZE after inserting 5000 more rows. The stats will be
>> out of date.
>>
>> Thom
>>
>
>
