| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Summer S(dot) Wilson" <collectonian(at)eclectic-world(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Vacuum |
| Date: | 2001-10-08 16:03:54 |
| Message-ID: | 1433.1002557034@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
"Summer S. Wilson" <collectonian(at)eclectic-world(dot)com> writes:
> I'm running PostgreSQL 7.1 with Slackware 8 on a dual processor Dell server.
> I have a database with 17 tables. I started VacuumDB with the analyze
> option on Friday around 3pm...when I came in this morning at 8 it was still
> not done. From the verbose info, it seems to be "stuck" on one table,
> whowrote which is the second largest table (2546 records).
Is it consuming CPU time, or just sitting? (ps or top would tell you)
If it's just sitting, I'd bet that there is some other connected backend
that's holding an open transaction with a lock on that table.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nick Fankhauser | 2001-10-08 16:07:40 | Re: buffer overflow (I'm getting it too!) |
| Previous Message | Stephan Szabo | 2001-10-08 16:00:54 | Re: buffer overflow (I'm getting it too!) |