Postgres Pro
Downloads
Home   >   mailing lists

Indexing large table of coordinates with GiST - Mailing list pgsql-general

From Daniel Begin
Subject Indexing large table of coordinates with GiST
Date
Msg-id COL129-DS12CF773E979C4FB54812E3944E0@phx.gbl
Whole thread Raw
Responses Re: Indexing large table of coordinates with GiST  (Vick Khera <vivek@khera.org>)
Re: Indexing large table of coordinates with GiST  (Andy Colson <andy@squeakycode.net>)
Re: Indexing large table of coordinates with GiST  (Rob Sargent <robjsargent@gmail.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: M Tarkeshwar Rao
Date:
Subject: can you have any idea about toast missing chunk issu resolution
Next
From: Vincent Veyron
Date:
Subject: Re: Need advice for handling big data in postgres