RE: New statistics for tuning WAL buffer size - Mailing list pgsql-hackers

From tsunakawa.takay@fujitsu.com
Subject RE: New statistics for tuning WAL buffer size
Date
Msg-id TYAPR01MB2990FBA54A06A0A2D39C5FAEFE5B0@TYAPR01MB2990.jpnprd01.prod.outlook.com
Whole thread Raw
In response to Re: New statistics for tuning WAL buffer size  (Fujii Masao <masao.fujii@oss.nttdata.com>)
Responses Re: New statistics for tuning WAL buffer size  (Fujii Masao <masao.fujii@oss.nttdata.com>)
List pgsql-hackers
From: Fujii Masao <masao.fujii@oss.nttdata.com>
> Just idea; it may be worth exposing the number of when new WAL file is
> created and zero-filled. This initialization may have impact on
> the performance of write-heavy workload generating lots of WAL. If this
> number is reported high, to reduce the number of this initialization,
> we can tune WAL-related parameters so that more "recycled" WAL files
> can be hold.

Sounds good.  Actually, I want to know how much those zeroing affected the transaction response times, but it may be
thetarget of the wait event statistics that Imai-san is addressing.
 

(I wonder how the fallocate() patch went that tries to minimize the zeroing time.)


Regards
Takayuki Tsunakawa


pgsql-hackers by date:

Previous
From: "tsunakawa.takay@fujitsu.com"
Date:
Subject: RE: New statistics for tuning WAL buffer size
Next
From: Fujii Masao
Date:
Subject: Re: New statistics for tuning WAL buffer size