[postgis-users] Strange result about spatial indexes?

[Mark Cave-Ayland]

Jose Carlos wrote:

> Hi,
> I made the table smaller for sharing. Now the table has just 1600 rows.
> The effect still remains.  I tried with others tables and other PostGIS
> versions, I tried even just with tables with POINT features getting similar
> results.
> 
> Thanx,
> Best
> 
> You can download the table from here:
> http://cid-40b8dee7bf5b661f.skydrive.live.com/self.aspx/.Public/data.tgz

Great, thanks for this! I'll see if I can find some time over the 
weekend to find out what's happening in this test case.


ATB,

Mark.

-- 
Mark Cave-Ayland - Senior Technical Architect
PostgreSQL - PostGIS
Sirius Corporation plc - control through freedom
http://www.siriusit.co.uk
t: +44 870 608 0063

Sirius Labs: http://www.siriusit.co.uk/labs