Home > mailing lists

Less is More - Mailing list pgsql-general

From	Paul Ramsey
Subject	Less is More
Date	June 22, 2015 16:09:45
Msg-id	etPan.55880908.41b71efb.173ac@Crane.local Whole thread Raw
Responses	Re: Less is More
List	pgsql-general

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

From: Christian Ramseyer
Date: 22 June 2015, 14:53:04
Subject: How to speed up pg_trgm / gin index scan

From: Tom Lane
Date: 22 June 2015, 16:18:59
Subject: Re: Less is More