[postgis-devel] Re: [postgis-users] create tables smarter
Mark Cave-Ayland
mark.cave-ayland at siriusit.co.uk
Fri Jun 6 09:09:18 PDT 2008
Markus Schaber wrote:
> Hi, David,
>
> "David William Bitner" <david.bitner at gmail.com> wrote:
>
>> I'm not actually doing this, but I helped someone else on IRC set this up a
>> while ago because the overlaps operator for time does not make use of any
>> indexes on time data types. The solution that he used was to create 1-d
>> lines (ie 0 1,0 5) that represented a time period so he could just use &&
>> for an indexed overlaps operator. A little hacky, but it seemed to work
>> quite well for him.
>
> Then the way to go would be to fix the time data types.
>
> Regards,
> Markus
I guess so. I don't know whether SQL OVERLAPS() will use the indexes,
however the standard GiST R-Tree && operator should do without any problems.
ATB,
Mark.
--
Mark Cave-Ayland
Sirius Corporation - The Open Source Experts
http://www.siriusit.co.uk
T: +44 870 608 0063
More information about the postgis-devel
mailing list