Re: Indexing large table of coordinates with GiST

[Rémi Cura <remi.cura@xxxxxxxxx>]

Hey,

You may want to post this on postGIS list.

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

2015-01-15 15:45 GMT+01:00 Andy Colson <andy@xxxxxxxxxxxxxxx>:

On 1/15/2015 6:44 AM, Daniel Begin wrote:

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 :-)

Any idea?

Daniel

Set maintenance_work_mem as large as you can.

-Andy

--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general