Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgres, fsync, and OSs (specifically linux) - Mailing list pgsql-hackers

From Thomas Munro
Subject Re: Postgres, fsync, and OSs (specifically linux)
Date
Msg-id CAEepm=1k+-w_8cfr8eXWNx=7HUZzPqyzD-4CD3_=3OeDuParVg@mail.gmail.com
Whole thread Raw
In response to Re: Postgres, fsync, and OSs (specifically linux)  (Thomas Munro <thomas.munro@enterprisedb.com>)
List pgsql-hackers
Tree view 
On Mon, Apr 30, 2018 at 11:02 AM, Thomas Munro
<thomas.munro@enterprisedb.com> wrote:
> MySQL: The default is still buffered

Someone pulled me up on this off-list: the default is buffered (fsync)
on Unix, but it's unbuffered on Windows.  That's quite interesting.

https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html#sysvar_innodb_flush_method
https://mariadb.com/kb/en/library/xtradbinnodb-server-system-variables/#innodb_flush_method

-- 
Thomas Munro
http://www.enterprisedb.com

pgsql-hackers by date:

Previous
From: David Rowley
Date:
Subject: Re: power() function in Windows: "value out of range: underflow"
Next
From: Thomas Munro
Date:
Subject: Re: Postgres, fsync, and OSs (specifically linux)