| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "PostgreSQL" <martin(at)portant(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: 8.1beta3 performance |
| Date: | 2005-11-02 14:41:14 |
| Message-ID: | 5353.1130942474@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
"PostgreSQL" <martin(at)portant(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joost Kraaijeveld | 2005-11-02 14:41:31 | Re: pgbench results interpretation? |
| Previous Message | Magnus Hagander | 2005-11-02 13:54:14 | Re: insert performance for win32 |