Hey all,
I have an odd performance quirk I wonder if anyone has any theories for… (not a one-time result, table all heated up, etc)
spain=# explain analyze select way from planet_osm_point; QUERY PLAN
-----------------------------------------------------------------------------------------------------------------------------
Seq Scan on planet_osm_point (cost=0.00..37240.97 rows=
1748797 width=32) (actual time=0.044..813.521 rows=
1748797 loops=1)
Total runtime: 902.256 ms
(2 rows)
Time: 902.690 ms
spain=# explain analyze select * from planet_osm_point;
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------
Seq Scan on planet_osm_point (cost=0.00..37240.97 rows=
1748797 width=848) (actual time=0.051..241.413 rows=
1748797 loops=1)
Total runtime: 330.271 ms
(2 rows)
Time: 331.869 ms
Thanks,
--
http://postgis.nethttp://cleverelephant.ca