Re: Indexing large table of coordinates with GiST

I'd restructure the table to be split into perhaps 100 or so inherited
tables (or more). That many rows in a table are usually not efficient with
postgres in my experience. My target is to keep the tables under about 100
million rows. I slice them up based on the common query patterns, usually
by some ID number modulo 100. I don't really ever use date ranges like most
tutorials you'll see will suggest.

On Thu, Jan 15, 2015 at 7:44 AM, Daniel Begin <jfd553(at)hotmail(dot)com> 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
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>