Thanks Kevin. I thought about using tsearch2 but I need to be able to select
exact values on other numerical queries and cannot use "contains" queries.
It's got to be fast so I cannot have lots of records returned and have to do
secondary processing on the xml for the records which contain the exact
value I'm looking for. This is one of the reasons I moved from using Lucene
for searching. I hope this makes sense.
Kevin Grittner wrote:
> wrote:
>
>
> I would try to minimize how many XML values it had to read, parse, and
> search. The best approach that comes to mind would be to use tsearch2
> techniques (with a GIN or GiST index on the tsvector) to identify
> which rows contain 'fdc3da1f-060f-4c34-9c30-d9334d9272ae', and use AND
> to combine that with your xpath search.
>
> -Kevin
>
>
>
--
View this message in context: http://www.nabble.com/Slow-select-times-on-select-with-xpath-tp25259351p25530439.html
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.