Re: BUG #14238: crate index hang - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #14238: crate index hang
Date
Msg-id 7339.1467993357@sss.pgh.pa.us
Whole thread Raw
In response to BUG #14238: crate index hang  (guang-dih.lei@nasa.gov)
List pgsql-bugs
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

pgsql-bugs by date:

Previous
From: guang-dih.lei@nasa.gov
Date:
Subject: BUG #14238: crate index hang
Next
From: Noah Misch
Date:
Subject: Re: BUG #14230: Wrong timeline returned by pg_stop_backup on a standby