I have a large geometry (MultiPolygon) for a (fictional) world map. It basically spans a large portion of the entire world: it's the difference between a buffered extension of the union of the entire world geometry and that union itself. In other words, a coastal buffer.
The geometry is in a PostGIS table (as one record). I serve this using GeoServer over WMS. Does it make sense to (automatically) split this giant geometry up into smaller ones, or is that completely unnecessary because PostGIS and/or GeoServer use the appropriate (sufficiently fast) intersection queries?
I'm not having a performance problem with this (yet) but the question is nagging at me.