Geospatial Types
Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
Geospatial types contain information about points, paths, and polygons on the surface of the Earth.
Data Type |
Size |
Size (Not Null) |
---|---|---|
GEOGRAPHYPOINT |
8 bytes |
8 bytes |
GEOGRAPHY |
See note |
Important
The space consumed by the path and polygon data in Geography
columns is dependent on the complexity of the objects.Geography
value consumes 24 bytes per vertex, plus a 64 byte overhead, plus some minor overhead for each “ring” in a multipolygon.
Indexing a Geography
object may also consume more space than indexes over other data types.
Last modified: March 8, 2024