| From: | "Magnus Hagander" <mha(at)sollentuna(dot)net> |
|---|---|
| To: | <weisong44(at)gmail(dot)com>, <pgsql-bugs(at)postgresql(dot)org>, <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Hanging queries on Windows 2003 SP1 |
| Date: | 2006-09-04 11:39:40 |
| Message-ID: | 6BCB9D8A16AC4241919521715F4D8BCEA3561C@algol.sollentuna.se |
| 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
>
There have been some fairly extensive changes in the semaphore code for
8.2. Any chance you can try the cvs snapshot version and see if the
problem exists there as well?
//Magnus
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Daniel Migowski | 2006-09-04 13:13:08 | Wishlist: Please ad a switch to dectivate the comments in the dump |
| Previous Message | Andrew - Supernews | 2006-09-04 07:56:09 | Re: BUG #2599: AM/PM doesn't work in to_timestamp in |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Guillaume Cottenceau | 2006-09-04 12:07:37 | Re: increasing shared buffers: how much should be removed from OS filesystem cache? |
| Previous Message | Markus Schaber | 2006-09-04 07:35:13 | Re: database bloat,non removovable rows, slow query etc... |