using zfs，you can tune full page write off for pg，which can save wal write
io.
2016年7月29日 2:05 PM，"trafdev" 写道：
> Hi.
>
> I have an OLAP-oriented DB (light occasional bulk writes and heavy
> aggregated selects over large periods of data) based on Postgres 9.5.3.
>
> Server is a FreeBSD 10.3 with
+1
larger record size can increase compression ratio，so reduce the io.
Did you set atime off for zfs?
2016年9月28日 6:16 AM，"Karl Denninger" 写道：
> On 9/27/2016 16:38, Tomas Vondra wrote:
>
> On 09/27/2016 06:00 PM, Torsten Zuehlsdorff wrote:
>
>
>
> On 29.07.2016 08:30, Tomas Vondra wrote:
>
>
>
>
what is the cmd？the default checkpoint method is spread,so pg_basebackup
will wait the checkpoint complete on the master.you can set the checkpoint
method to fast to avoid the waiting.
2014年10月7日 2:54 AM于 "Mike Blackwell" 写道：
> I'm seeing some strange behavior running pg_basebackup on 9.3.5. It
>
