RE: [PoC] Non-volatile WAL buffer - Mailing list pgsql-hackers

From tsunakawa.takay@fujitsu.com
Subject RE: [PoC] Non-volatile WAL buffer
Date
Msg-id TYAPR01MB2990BA17E8C3DA259B327EE3FEFB0@TYAPR01MB2990.jpnprd01.prod.outlook.com
Whole thread Raw
In response to Re: [PoC] Non-volatile WAL buffer  (Tomas Vondra <tomas.vondra@enterprisedb.com>)
Responses Re: [PoC] Non-volatile WAL buffer
List pgsql-hackers
From: Tomas Vondra <tomas.vondra@enterprisedb.com>
> So I wonder if using PMEM for the WAL buffer is the right way forward.
> AFAIK the WAL buffer is quite concurrent (multiple clients writing
> data), which seems to contradict the PMEM vs. DRAM trade-offs.
> 
> The design I've originally expected would look more like this
> 
>     clients -> wal buffers (DRAM) -> wal segments (PMEM DAX)
> 
> i.e. mostly what we have now, but instead of writing the WAL segments
> "the usual way" we'd write them using mmap/memcpy, without fsync.
> 
> I suppose that's what Heikki meant too, but I'm not sure.

SQL Server probably does so.  Please see the following page and the links in "Next steps" section.  I'm saying
"probably"because the document doesn't clearly state whether SQL Server memcpys data from DRAM log cache to
non-volatilelog cache only for transaction commits or for all log cache writes.  I presume the former.
 


Add persisted log buffer to a database
https://docs.microsoft.com/en-us/sql/relational-databases/databases/add-persisted-log-buffer?view=sql-server-ver15
--------------------------------------------------
With non-volatile, tail of the log storage the pattern is

memcpy to LC
memcpy to NV LC
Set status
Return control to caller (commit is now valid)
...

With this new functionality, we use a region of memory which is mapped to a file on a DAX volume to hold that buffer.
Sincethe memory hosted by the DAX volume is already persistent, we have no need to perform a separate flush, and can
immediatelycontinue with processing the next operation. Data is flushed from this buffer to more traditional storage in
thebackground.
 
--------------------------------------------------



Regards
Takayuki Tsunakawa


pgsql-hackers by date:

Previous
From: Li Japin
Date:
Subject: Re: Use macros for calculating LWLock offset
Next
From: Fujii Masao
Date:
Subject: Re: walsender bug: stuck during shutdown