[postgis-users] tsearch

[Obe, Regina]

Robert,
Haven't tried personally myself, but don't see a reason why it wouldn't.

With the introduction of bitmap indexes in PostgreSQL 8.1+, I suspect it would be able to simultaneously take advantage of both a spatial gist index as well as the full text gist/gin index.  Worst case it will choose one index over another when querying a table that has both spatial gist and fulltext gist/gin.  But that's the same deal with attribute indexes anyway except in the attribute case - an attribute index is the clear winner.  

I'm not quite sure which will perform better a full text index search or spatial index search and I'm not sure the planner knows either since the indexes are of the same family.

I say go for it and I'd be interested in knowing how it works out since I suspect I will need to do the same thing in the near future.

Hope that helps,
Regina

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net on behalf of Robert Najlis
Sent: Wed 9/24/2008 12:29 PM
To: postgis-users at postgis.refractions.net
Subject: [postgis-users] tsearch
 
Hi, I am new to postgis, but I am working with location and distance
based searches (as well as regular text searching).  I was wondering
if tsearch can work together with a postgis database to do
distance based searches (as well as regular text based searches)?

Thanks a lot for your help.

Robert



-----------------------------------------
The substance of this message, including any attachments, may be
confidential, legally privileged and/or exempt from disclosure
pursuant to Massachusetts law. It is intended
solely for the addressee. If you received this in error, please
contact the sender and delete the material from any computer.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20080924/46d445c5/attachment.html>