Re: [HACKERS] An attempt to reduce WALWriteLock contention

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: [HACKERS] An attempt to reduce WALWriteLock contention
Дата
Msg-id 20170622012406.5u5iaywrtft565nx@alap3.anarazel.de
обсуждение исходный текст
Ответ на Re: [HACKERS] An attempt to reduce WALWriteLock contention  (jasrajd <jasrajd@microsoft.com>)
Ответы Re: [HACKERS] An attempt to reduce WALWriteLock contention  (Amit Kapila <amit.kapila16@gmail.com>)
Список 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



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: [HACKERS] PATCH: Batch/pipelining support for libpq
Следующее
От: Thomas Munro
Дата:
Сообщение: Re: [HACKERS] ASOF join