guang-dih.lei@nasa.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