<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7652.24">
<TITLE>RE: [postgis-users] tsearch</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/plain format -->
<P><FONT SIZE=2>Robert,<BR>
Haven't tried personally myself, but don't see a reason why it wouldn't.<BR>
<BR>
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. <BR>
<BR>
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.<BR>
<BR>
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.<BR>
<BR>
Hope that helps,<BR>
Regina<BR>
<BR>
-----Original Message-----<BR>
From: postgis-users-bounces@postgis.refractions.net on behalf of Robert Najlis<BR>
Sent: Wed 9/24/2008 12:29 PM<BR>
To: postgis-users@postgis.refractions.net<BR>
Subject: [postgis-users] tsearch<BR>
<BR>
Hi, I am new to postgis, but I am working with location and distance<BR>
based searches (as well as regular text searching). I was wondering<BR>
if tsearch can work together with a postgis database to do<BR>
distance based searches (as well as regular text based searches)?<BR>
<BR>
Thanks a lot for your help.<BR>
<BR>
Robert<BR>
<BR>
</FONT>
</P>
</BODY>
</HTML>
<HTML><BODY><P><hr size=1></P>
<P><STRONG>
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.
</STRONG></P></BODY></HTML>
<P><hr size=1></P>
<P><STRONG><font size="2" color="339900"> Help make the earth a greener place. If at all possible resist printing this email and join us in saving paper. </p> <p> </font></STRONG></P>