[postgis-devel] Issue 18 in postgis: Remove RECHECK requirement on index

[codesite-noreply at google.com]

Updates:
	Status: Fixed

Comment #6 on issue 18 by pwramsey3: Remove RECHECK requirement on index
http://code.google.com/p/postgis/issues/detail?id=18

An individual data point:

select sum(v.ndp) from vada2005 v join ed2000 e on  
(st_intersects(v.the_geom, e.the_geom));

-- recheck = false

Time: 4101.556 ms
Time: 4027.646 ms
Time: 4013.932 ms
Time: 4082.649 ms

-- recheck = true

Time: 5312.517 ms
Time: 5419.429 ms
Time: 5293.803 ms
Time: 5219.899 ms
	


--
You received this message because you are listed in the owner
or CC fields of this issue, or because you starred this issue.
You may adjust your issue notification preferences at:
http://code.google.com/hosting/settings