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. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers