PostGIS Spatial Operations: How to Determine if a Point Lies Within a Polygon or Multipolygon

Conditional Switching between Indexed and Non-Indexed Operations in PostGIS for Performance Optimization