Can you tell me, in how much time did the query will take with indexes +
tsearch2?
How much time take a satisfactory query?
Can you show me some examples with tsearch2 and xml indexes?
Thanks
On Jan 9, 2008 6:00 PM, x asasaxax <[EMAIL PROTECTED]> wrote:
> My Postgre version its the 8.2. I´ve reached to do the path i wanted, but
> when i do a explain analyze on the select it return 500 miliseconds. Is this
> a good search? Is there a way to slow down this time with postgre 8.3? What
> is
My Postgre version its the 8.2. I´ve reached to do the path i wanted, but
when i do a explain analyze on the select it return 500 miliseconds. Is this
a good search? Is there a way to slow down this time with postgre 8.3? What
is a good time for xml xpath´s?
Thanks
2008/1/8, x asasaxax <[EMAIL PR
On Jan 8, 2008 11:21 PM, x asasaxax <[EMAIL PROTECTED]> wrote:
> Hi everyone,
>
>I´m trying to undestand how to do select with xml path.
First of all, what is your Postgres version? 8.3 with xml support or
older one with conrib/xml2?
In case of 8.3, you can find some examples in current docs:
Hi everyone,
I´m trying to undestand how to do select with xml path.
I have this xml example:
create table temp(id integer, xml text, Primary Key(id));
