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

codesite-noreply at google.com codesite-noreply at google.com
Mon Feb 2 15:38:12 PST 2009


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



More information about the postgis-devel mailing list