"PostgreSQL" <[EMAIL PROTECTED]> 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

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply via email to