title: PostGIS query to Select all Polygons from Polygon table having an intersecting geometry with one or more point in passed list of GeoCoordinates
body: <p>I have a polygons table in Postgres (using PostGIS extension) named polygon having two fields (geom, id).</p>
  <p>If I want to query the id of the polygon which intersects with the geometry of input geo-coordinate then I can do it with the below query.</p>
  <pre><code>SELECT id, geom 
  FROM polygon 
  WHERE ST_Intersects(polygon.%s, ST_GeometryFromText(POINT(latitude logitude), 4326));
  </code></pre>
  <p>But now I have a use case where I am getting a lot of geo-coordinates in request(~60k), now I am breaking this into lists of 1k Geo-coordinate each and querying the id of the polygon intersecting with each geo-coordinate.</p>
  <p>I am struggling with how to write. a query for this, or if anyone has a better solution for this please suggest.</p>