Re: An attempt to reduce WALWriteLock contention

From: Andres Freund <andres(at)anarazel(dot)de>
To: jasrajd <jasrajd(at)microsoft(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: An attempt to reduce WALWriteLock contention
Date: 2017-06-22 01:24:06
Message-ID: 20170622012406.5u5iaywrtft565nx@alap3.anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 2017-06-21 00:57:32 -0700, jasrajd wrote:
> We are also seeing contention on the walwritelock and repeated writes to the
> same offset if we move the flush outside the lock in the Azure environment.
> pgbench doesn't scale beyond ~8 cores without saturating the IOPs or
> bandwidth. Is there more work being done in this area?

I kind of doubt that scalability limit is directly related to this patch
- I've seen postgres scale furhter without that lock becoming the prime
issue. What exactly are you measuring / observing?

Andres Freund

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Thomas Munro 2017-06-22 01:30:06 Re: ASOF join
Previous Message Andres Freund 2017-06-22 01:21:55 Re: PATCH: Batch/pipelining support for libpq