New answers tagged postgis
0
votes
Postgres slow query on large tables when doing a search radius search and joining on large tables with indices
Because your column is of type "geometry", the distance is being measured in degrees. Every place on Earth is within 1609.354 * 50 degrees of every other place on Earth, so this is ...
Top 50 recent answers are included
Related Tags
postgis × 284postgresql × 247
spatial × 37
performance × 27
query-performance × 17
index × 17
postgresql-performance × 17
postgresql-9.3 × 12
ubuntu × 11
pg-dump × 9
gist-index × 9
nearest-neighbor × 8
amazon-rds × 7
postgresql-9.6 × 7
postgresql-9.1 × 7
geometry × 7
database-design × 6
upgrade × 6
postgresql-extensions × 6
pgrouting × 6
trigger × 5
subquery × 5
postgresql-9.4 × 5
plpgsql × 5
postgresql-10 × 5