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 wrote:
> Tried that same thing
>
>
> On Thu, May 27, 2010 at 1:53 PM, Thom Brown wrote:
>
>>
Tried that same thing
On Thu, May 27, 2010 at 1:53 PM, Thom Brown wrote:
> On 27 May 2010 12:22, Chris Roffler wrote:
> > I have a table with an xml column, created an index as follows:
> > CREATE INDEX xml_index
> > ON test
> > USING btree
> > (((x
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()', extern
Richard
thanks for the pointers unfortunately its not just attribute names.
Here is what I am thinking of doing;
In a first step I run a query
SELECT id FROM time_series WHERE
to_tsvector(xml_string)
@@
to_tsquery( anystring );
then I load the actual xml string into memory for each i
Huxton wrote:
> On 16/03/10 10:29, Chris Roffler wrote:
>
>> I have a text column in a table. We store XML in this column. Now I want
>> to
>> search for tags and values
>>
>
> select * from where to_tsvector('english',xml_column) @@
>> to
I have a text column in a table. We store XML in this column. Now I want to
search for tags and values
Example data:
Citi Bank
.
.
/
I would like to run the following query:
select * from where to_tsvector('english',xml_column) @@
to_tsquery('Citi
Bank')
This works fine but
wrote:
> On 8 Mar 2010, at 11:39, Chris Roffler wrote:
>
> > Alban
> >
> > Thanks for your help, your suggestion worked.
> >
> > I need another xpath expression to find any Attribute with Name =""
> under the Attributes node. (not just if it is in
Attribute102021
1
2010-03-05T05:44:36.796-05:00
Chris
Attribute202021
2
2010-03-05T05:44:36.796-05:00
Maya
On Mon, Mar 8, 2010 at 1:27 PM, Alban Hertroys <
dal...@
SELECT * FROM time_series
WHERE
array_upper((xpath('/AttributeList/Attributes/Attribute[Name="x"]',
external_attributes)),1) > 0
On Sun, Mar 7, 2010 at 1:11 PM, Alban Hertroys <
dal...@solfertje.student.utwente.nl> wrote:
> On 7 Mar 2010, at 11:02, Ch
I still have some problems with my xml index
CREATE INDEX xml_index
ON time_series
USING btree
((
(xpath('/AttributeList/Attributes/Attribute/Name/text()',
external_attributes))[1]::text));
When I run the following query the index is not used :
select id from time_series where
array_uppe
Are there any guidelines for XML performance tuning ?
Thanks
Chris
at 4:18 PM, Chris Roffler wrote:
> Thanks for your fast response
>
> I have the following sql statement now :
>
> CREATE INDEX xml_index
> ON time_series
> USING btree
>
> (xpath('/AttributeList/Attributes/Attribute/Name/text()',external_attributes))[1]
r "["
LINE 6: ...butes/Attribute/Name/text()',external_attributes))[1]::text;
Any idea ?
Thanks
Chris
^
On Fri, Mar 5, 2010 at 3:22 PM, Tom Lane wrote:
> Chris Roffler writes:
> > I am trying to setup an index on an xpath expression but the query never
>
I am trying to setup an index on an xpath expression but the query never
uses the index.
Could someone enlighten me please ?
Here is the setup :
CREATE TABLE time_series
(
id bigint NOT NULL,
"name" character varying NOT NULL,
"timestamp" timestamp with time zone NOT NULL,
start_date time
14 matches
Mail list logo
