[postgis-devel] Forget what I said
Paragon Corporation
lr at pcorp.us
Thu Dec 30 23:55:18 PST 2010
Its slower
SELECT count(p1.*)
from par35 As p1 INNER JOIN par35 As p2 ON p1.the_geom && p2.the_geom
WHERE p2.map_id LIKE '0101%';
On gserialized: 1,076 ms
On regular (9.1 though no gserialized) -- 110ms
So I guess the network effects of returning the dataset was taking up the
chunk of my last timing.
I still need to do a 9.0 to 9.0 compare to be fair.
More information about the postgis-devel
mailing list