"PostgreSQL" <martin@xxxxxxxxxxx> 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
