Re: WALWriteLock contention - Mailing list pgsql-hackers

From Tom Lane
Subject Re: WALWriteLock contention
Date
Msg-id 4841.1431709743@sss.pgh.pa.us
Whole thread Raw
In response to WALWriteLock contention  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: WALWriteLock contention
List pgsql-hackers
Robert Haas <robertmhaas@gmail.com> writes:
> WALWriteLock contention is measurable on some workloads.  In studying
> the problem briefly, a couple of questions emerged:

> 1. Doesn't it suck to rewrite an entire 8kB block every time, instead
> of only the new bytes (and maybe a few bytes following that to spoil
> any old data that might be there)?

It does, but it's not clear how to avoid torn-write conditions without
that.

> 2. I don't really understand why WALWriteLock is set up to prohibit
> two backends from flushing WAL at the same time.  That seems
> unnecessary.

Hm, perhaps so.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Changes to backup.sgml
Next
From: Volker Aßmann
Date:
Subject: Re: Disabling trust/ident authentication configure option