Re: BUG #2710: Intermittent hangs on sequence generation

"Jason Palmer" <jpalmer(at)dlife(dot)com> writes:
> ... What we experience is bizarre. We can always
> create tables with no sequences. But occasionally the database will hang
> when we attempt to create a table with a sequence or foreign key.

Yup, that's pretty bizarre. Is the backend consuming CPU (or I/O) in
this state, or is it just waiting? If the latter, it's presumably
blocked on some lock, and you need to find out what. First try looking
in pg_locks to see if it's blocked on a user-level lock. If you don't
see anything there, then it's blocked on some internal lock (LWLock or
spinlock) --- you'll need to attach to the backend process with gdb and
get a stack trace to get some clue what's up.

regards, tom lane