[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