Skip to main content

New answers tagged

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 ...
jjanes's user avatar
  • 41.3k

Top 50 recent answers are included