"PostgreSQL" <martin@portant.com> writes:
> I'm seeing some other little oddities in the beta as well. I'm watching an
> ALTER TABLE ADD COLUMN right now that has been running almost two hours. I
> stopped it the first time at 1 hour; I suppose I'll let it go this time and
> see if it ever completes. The table is about 150K rows. Top, vmstat, and
> iostat show almost no cpu or disk activity (1 to 3%) - it's as if it just
> went to sleep.
You sure it's not blocked on a lock? Check pg_locks ... if that sheds
no light, try attaching to the backend process with gdb and getting a
stack trace.
regards, tom lane
