SQLsqlselect*,st_distance_sphere(geometry(poi),geometry('POINT(116.4173939.913164)'))distancefromtestorderbydistanceasclimit10EXPLAIN結(jié)果：Limit(cost=14826.00..14826.02rows=10width=51)->Sort(cost=14826.00..14950.85rows=49939width=51)SortKey:(_st_distance(geography(geometry(poi)),'0101000020E61000005BEB8B84B61A5D4039F1D58EE2F44340'::geography,0::doubleprecision,false))->SeqScanontest(cost=0.00..13746.83rows=49939width=51)已經(jīng)給poi建立了gist索引了……為啥卻沒用呢？才12w數(shù)據(jù)，檢索卻要0.6s表結(jié)構(gòu)idserial8primarykeynotnull,namevarchar(80)notnulldefault'',poist_geometryfromtext('POINT(112.123,23.111)',4326)索引createindexpoiontestusinggist(poi)