Re: Indexing large table of coordinates with GiST
| От | Vick Khera |
|---|---|
| Тема | Re: Indexing large table of coordinates with GiST |
| Дата | |
| Msg-id | CALd+dccOeL5qLm8jut1JxENKt7tMOFeXcnqS4MBgmu3TjGAJfg@mail.gmail.com обсуждение исходный текст |
| Ответ на | Indexing large table of coordinates with GiST (Daniel Begin <jfd553@hotmail.com>) |
| Список | pgsql-general |
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@hotmail.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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
В списке pgsql-general по дате отправления: