From:
Jeff Davis <pgsql(at)j-davis(dot)com>
To:
cedric(at)2ndquadrant(dot)com
Cc:
pgsql-hackers(at)postgresql(dot)org, Andres Freund <andres(at)anarazel(dot)de>, Robert
Haas <robertmhaas(at)gmail(dot)com>, Noah Misch <noah(at)leadboat(dot)com>, Tom Lane
<tgl(at)sss(dot)pgh(dot)pa(dot)us>, Andrew Dunstan <andrew(at)dunslane(dot)net>
Subject:
Re: initdb and fsync
Date:
2012-03-26 02:59:36
Message-ID:
1332730776.8251.93.camel@jdavis (view raw or flat )
Thread:
2012-01-28 00:19:41 from Jeff Davis <pgsql(at)j-davis(dot)com>
2012-01-28 04:52:19 from Noah Misch <noah(at)leadboat(dot)com>
2012-01-28 15:31:57 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2012-01-28 18:16:11 from Jeff Davis <pgsql(at)j-davis(dot)com>
2012-01-28 18:18:00 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-01-28 18:46:06 from Jeff Davis <pgsql(at)j-davis(dot)com>
2012-01-28 18:59:51 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2012-01-28 18:57:03 from Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
2012-02-04 21:20:05 from Florian Weimer <fw(at)deneb(dot)enyo(dot)de>
2012-02-04 23:41:27 from Jeff Davis <pgsql(at)j-davis(dot)com>
2012-02-05 01:18:49 from Noah Misch <noah(at)leadboat(dot)com>
2012-02-05 18:53:20 from Jeff Davis <pgsql(at)j-davis(dot)com>
2012-02-05 19:50:20 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-02-05 22:56:57 from Noah Misch <noah(at)leadboat(dot)com>
2012-03-13 03:49:40 from Jeff Davis <pgsql(at)j-davis(dot)com>
2012-03-13 08:42:03 from Andres Freund <andres(at)anarazel(dot)de>
2012-03-14 04:23:03 from Jeff Davis <pgsql(at)j-davis(dot)com>
2012-03-14 09:26:17 from Andres Freund <andres(at)anarazel(dot)de>
2012-03-15 06:38:38 from Jeff Davis <pgsql(at)j-davis(dot)com>
2012-03-16 10:25:01 from Andres Freund <andres(at)anarazel(dot)de>
2012-03-16 15:47:06 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-03-16 15:51:04 from Andres Freund <andres(at)anarazel(dot)de>
2012-03-17 16:48:38 from Cédric Villemain <cedric(at)2ndquadrant(dot)com>
2012-03-26 02:59:36 from Jeff Davis <pgsql(at)j-davis(dot)com>
2012-06-13 04:09:11 from Jeff Davis <pgsql(at)j-davis(dot)com>
2012-06-13 10:53:03 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2012-06-13 16:53:17 from Jeff Davis <pgsql(at)j-davis(dot)com>
2012-06-18 16:05:29 from Andres Freund <andres(at)2ndquadrant(dot)com>
2012-06-18 18:34:30 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2012-06-18 18:52:25 from Jeff Davis <pgsql(at)j-davis(dot)com>
2012-06-19 15:33:30 from David Fetter <david(at)fetter(dot)org>
2012-06-18 18:39:47 from Jeff Davis <pgsql(at)j-davis(dot)com>
2012-06-18 18:57:51 from Andres Freund <andres(at)2ndquadrant(dot)com>
2012-06-18 19:32:25 from Jeff Davis <pgsql(at)j-davis(dot)com>
2012-06-18 19:41:01 from Andres Freund <andres(at)2ndquadrant(dot)com>
2012-06-18 19:55:27 from Jeff Davis <pgsql(at)j-davis(dot)com>
2012-06-19 17:22:02 from Jeff Davis <pgsql(at)j-davis(dot)com>
2012-06-19 17:25:40 from Andres Freund <andres(at)2ndquadrant(dot)com>
2012-07-13 18:19:44 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-07-13 21:35:06 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-07-13 23:25:39 from Jeff Davis <pgsql(at)j-davis(dot)com>
2012-07-13 23:43:14 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-06-18 19:43:52 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2012-07-13 19:21:27 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-07-13 21:41:41 from Jeff Davis <pgsql(at)j-davis(dot)com>
2012-07-13 22:11:37 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-06-23 21:34:27 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2012-03-16 17:14:49 from Jeff Davis <pgsql(at)j-davis(dot)com>
2012-02-10 20:57:52 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2012-02-13 13:14:52 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-06-22 14:04:23 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-06-23 01:46:52 from Noah Misch <noah(at)leadboat(dot)com>
2012-06-23 09:17:45 from Jeff Davis <pgsql(at)j-davis(dot)com>
2012-01-28 18:27:14 from Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
Lists:
pgsql-hackers
On Sat, 2012-03-17 at 17:48 +0100, Cédric Villemain wrote:
> I agree with Andres.
>
>
> I believe we should use sync_file_range (_before?) with linux.
>
> And we can use posix_fadvise_dontneed on other kernels.
>
OK, updated patch attached. sync_file_range() is preferred,
posix_fadvise() is a fallback.
Regards,
Jeff Davis
In response to
Responses
pgsql-hackers by date
Next :From: Magnus HaganderDate: 2012-03-26 06:50:24Subject : Re: Reporting WAL file containing checkpoint's REDO record
in pg_controldata's resultPrevious :From : Joachim WielandDate : 2012-03-26 02:50:51Subject : Re: patch for parallel pg_dump
