guang-dih(dot)lei(at)nasa(dot)gov writes:
> I have a table with around 108 millions records. After I issued the
> following 'create index' command, it just hang and can never finish:
Can you collect a few stack traces after activity seems to end?
https://wiki.postgresql.org/wiki/Generating_a_stack_trace_of_a_PostgreSQL_backend
regards, tom lane