| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Brian Hurt <bhurt(at)janestcapital(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org, pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: Postgres locking up? |
| Date: | 2006-09-29 20:58:05 |
| Message-ID: | 3233.1159563485@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice pgsql-performance |
Brian Hurt <bhurt(at)janestcapital(dot)com> writes:
> I'm experiencing a problem with our postgres database. Queries that
> normally take seconds suddenly start taking hours, if they complete at
> all.
Are they waiting? Consuming CPU? Consuming I/O? top and vmstat will
help you find out.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Frances Collier | 2006-09-29 21:24:44 | Re: Cancelled statement due to lost connection |
| Previous Message | Brandon Aiken | 2006-09-29 20:31:11 | Re: Cancelled statement due to lost connection |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | gurkan | 2006-09-29 21:36:12 | cont. how to optimize postgres 8.1 |
| Previous Message | Andrew Sullivan | 2006-09-29 19:30:06 | Re: Postgres locking up? |