или внеочередные заметки

Previous Entry Share Next Entry
What's wrong with postgis ?
trekking, Himalaya
During our work on conference talk about spatial data (Bartunov, Korotkov and Karpov) we tested performance of radial query from 10^8 points on sphere using several available algorithms - q3c, pgsphere and postgis (geography). pgsphere and postgis make use R-tree and we expected similar performance, but from picture below one can see, that the best pgsphere (with our improvements, pink triangles) outperforms postgis (grey triangles) about 2 order of magnitudes !

Radial Query

We hope, that postgis people will pay attention to this problem and probably we could greatly improve its performance.
Tags: ,


Log in