Apologies if this has been asked before; I found some similar questions (this mailing list post was particularly interesting: https://lists.osgeo.org/pipermail/postgis-users/2008-June/020353.html) but nothing quite satisfied my curiosity.
I have a table containing WGS84 data for a bunch of multipolygons (very large ones; multiple countries in most cases). I want to know which one contains an arbitrary point (where the point is also in WGS84 lat/long).
I am not sure if the geometry or the geography type is best suited for this. I implemented it first using geometry and it seems to work for some spot checks. I tried it with geography as well, and it was orders of magnitude slower.
1) Is geometry acceptable for modeling this, or will it have trouble?
2) If there will be some error using geometry, what are the error characteristics and magnitude to expect? (For example, will there be issues near boundaries of adjacent multipolygons, etc.)
ST_Contains doesn't work with geography columns, I guess
ST_Intersects would be the closest thing?