| From: | "weisong44(at)gmail(dot)com" <weisong44(at)gmail(dot)com> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org pgsql-performance(at)postgresql(dot)org |
| Subject: | Hanging queries on Windows 2003 SP1 |
| Date: | 2006-09-01 21:56:20 |
| Message-ID: | 1157147780.568274.141690@e3g2000cwe.googlegroups.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-performance |
Hi,
We are seeing hanging queries on Windows 2003 Server SP1 with dual CPU,
looks like one of the process is blocked. In a lot of cases, the whole
DB is blocked if this process is holding important locks.
Looks like this issue was discussed in the following thread a few month
ago, but didn't seem to have a solution mention. I would liek to know
if there is a patch for this already?
http://archives.postgresql.org/pgsql-performance/2006-03/msg00129.php
I would appreciate your feedbaek,
Thanks,
Wei
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marc ROGLIANO | 2006-09-02 00:26:48 | BUG #2606: (libpq) incorrect function declaration in libpq-fe.h |
| Previous Message | T.J. Ferraro | 2006-09-01 19:47:17 | Re: BUG #2604: Bug's |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Cramer | 2006-09-01 23:22:51 | Re: increasing shared buffers: how much should be removed from OS filesystem cache? |
| Previous Message | Dave Cramer | 2006-09-01 20:02:41 | Re: increasing shared buffers: how much should be removed from OS filesystem cache? |