Re: BUG #14238: crate index hang

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: guang-dih(dot)lei(at)nasa(dot)gov
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #14238: crate index hang
Date: 2016-07-08 15:55:57
Message-ID: 7339.1467993357@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Noah Misch 2016-07-09 01:52:05 Re: [BUGS] BUG #14230: Wrong timeline returned by pg_stop_backup on a standby
Previous Message guang-dih.lei 2016-07-08 15:17:47 BUG #14238: crate index hang