PostGIS Spatial Indexing: Why Your Queries Are Doing Sequential Scans

PostGIS Spatial Indexing: Why Your Queries Are Doing Sequential Scans Last year I helped a delivery platform debug why their "restaurants near me" feature was timing out during lunch rush. The restaurants table had 4.2 million rows. Every proximity q...