I take that so many rows mean either raster or point cloud.
If it is point cloud simply consider using pg_pointcloud.
A 6 billion point cloud is about 600 k lines for one of my data set.
If it is raster, you may consider using postgis raster type. If you really want to keep that much geometry, you may want to partition your data on a regular grid. Cheers, Rémi-C
Hi, I'm trying to create an index on coordinates (geography type) over a large table (4.5 billion records) using GiST...
CREATE INDEX nodes_geom_idx ON nodes USING gist (geom);
The command ran for 5 days until my computer stops because a power outage! Before restarting the index creation, I am asking the community if there are ways to shorten the time it took the first time :-)