Re: [9.4 bug] The database server hangs with write-heavy workload on Windows - Mailing list pgsql-hackers

From MauMau
Subject Re: [9.4 bug] The database server hangs with write-heavy workload on Windows
Date
Msg-id C14E24B014CB434EA821DE702EEC3253@maumau
Whole thread Raw
In response to Re: [9.4 bug] The database server hangs with write-heavy workload on Windows  ("MauMau" <maumau307@gmail.com>)
List pgsql-hackers
From: "MauMau" <maumau307@gmail.com>
> Thank you very much.  I didn't anticipate such a difficult complicated 
> cause.  The user agreed to try the patch tonight.  I'll report back the 
> result as soon as I got it from him.

The test ran successfully without hang for 24 hours.  It was run with your 
patch + the following:

> BTW, in LWLockWaitForVar(), the first line of the following code fragment 
> is not necessary, because lwWaitLink is set to head immediately.  I think 
> it would be good to eliminate as much unnecessary code as possible from 
> the spinlock section.
>
>  proc->lwWaitLink = NULL;
>
>  /* waiters are added to the front of the queue */
>  proc->lwWaitLink = lock->head;
>

Regards
MauMau




pgsql-hackers by date:

Previous
From: Lucas Lersch
Date:
Subject: Re: Buffer Requests Trace
Next
From: Alexander Korotkov
Date:
Subject: WIP: Access method extendability