concept big geometry in category postgis

appears as: big geometries, bigger geometries
PostGIS in Action, Third Edition

This is an excerpt from Manning's book PostGIS in Action, Third Edition.

  • If you have big geometries, having a second big geometry in your table slows down updates considerably, because PostgreSQL creates a copy of the original record during update and marks the original as deleted. It slows down selects too, because you have a fatter row to contend with.
  • Now that we’ve looked at functions that allow you to decompose a geometry, let’s take a look at composition functions that allow you to combine multiple geometries together to form bigger geometries.