[PostGIS] #5873: Postgres Topology and logical partitioning
PostGIS
trac at osgeo.org
Sun Mar 30 21:13:38 PDT 2025
#5873: Postgres Topology and logical partitioning
-------------------------------+------------------
Reporter: Lars Aksel Opsahl | Owner: strk
Type: enhancement | Status: new
Priority: medium | Milestone:
Component: topology | Version:
Keywords: |
-------------------------------+------------------
Last year, when working with big data that resulted in 80 million faces,
we had to do a lot of divide and conquer to get through. First, we had to
break topologies into many thousand small topologies that we could work on
in parallel and then merge into bigger and bigger topologies.
However, a single topology of 80 million faces does not work well for our
usage, so we split the temporary topology into around 20 smaller
topologies based on a content-based grid. These 20 topologies are
spatially not connected.
It would be nice if these 20 topologies could work similarly to table
partitioning in PostgreSQL by using some kind of new topology logical
partitioning.
--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5873>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.
More information about the postgis-tickets
mailing list