Suppose I have a table with a geometry column containing polygons created from points of lat and long values (SRID: 4326). Given an arbitrary lat and long location (again SRID: 4326) I want to query for polygons that contain the arbitrary point.
If your data is contained in a small area, you might find that choosing an appropriate projection and using GEOMETRY is the best solution, in terms of performance and functionality available.
And MySQL 5.8 has no dedicated geography type it seems.
How can I determine what the maximum "small area" described above is? In other words how can I determine the maximum area polygon I can store in PostGIS 2.3 and MySQL 5.8 Geometry columns before the results of a function like
ST_Contains will be wrong?