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.net http://cleverelephant.ca
