GIST create index very very slow

Поиск
Список
Период
Сортировка
От worthy7
Тема GIST create index very very slow
Дата
Msg-id 1408139959191-5815011.post@n5.nabble.com
обсуждение исходный текст
Ответы Re: GIST create index very very slow  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
CREATE INDEX USING GIST(timerange);

On 1.3 million rows this took only 30 seconds.
on 70 million its already taken over a day. I swear it didn't take this long
on version 9.3


Is there some kind of known bug with GIST? CPU is at 4% or less and ram is
at 150mbs
IO usage is at 100% but most of it is writes? (like 3.5mbps!) which looks
good but actually the size of the disk is only increasing by like 8 BYTES
per second.

This is really odd and I don't want to wait an indefinite amount of time.





--
View this message in context: http://postgresql.1045698.n5.nabble.com/GIST-create-index-very-very-slow-tp5815011.html
Sent from the PostgreSQL - hackers mailing list archive at Nabble.com.



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Arthur Silva
Дата:
Сообщение: Re: jsonb format is pessimal for toast compression
Следующее
От: Stefan Keller
Дата:
Сообщение: New Minmax index for geometry data type?