From: | Jeff Janes <jeff(dot)janes(at)gmail(dot)com> |
---|---|
To: | Thomas Kellerer <spam_eater(at)gmx(dot)net> |
Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Obsolete ToDo Item? |
Date: | 2014-07-16 21:39:03 |
Message-ID: | CAMkU=1zbbZjU+ufTnT5TNaRNfbFb7QA1CxxfzaA-OdtRYUdAvQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Wed, Jul 16, 2014 at 1:21 PM, Thomas Kellerer <spam_eater(at)gmx(dot)net> wrote:
> Hi,
>
> I was reading trough the ToDo list in the Postgres Wiki and noticed that
> one item for Fsync[1] seems to be obsolete:
>
> Determine optimal fdatasync/fsync, O_SYNC/O_DSYNC options and whether
> fsync does anything
> Ideally this requires a separate test program like
> /contrib/pg_test_fsync that can be run at initdb time or optionally later.
>
> This was added with 9.1[2] , so I guess that item can be removed from the
> Wiki page?
>
The to-do item is not for pg_test_fsync to be created, but rather for
initdb to automatically invoke pg_test_fsync and then analyze the results
and use that analysis to set up the fsync method.
But I do think this entry is obsolete. If a certain method is "too fast",
is that because the operating system lies and is not really syncing the
data, or is it because you have a BBU/NVRAM in front of the disk? Or
because you aren't using spinning disk at all? I don't think that there is
any way for initdb to safely figure out what is going on just based on the
outcome of some timing tests. The person who purchased the hardware has to
apply their knowledge.
Cheers,
Jeff
From | Date | Subject | |
---|---|---|---|
Next Message | Arup Rakshit | 2014-07-17 13:08:51 | How can I group all children by their parent ? |
Previous Message | Thomas Kellerer | 2014-07-16 20:21:27 | Obsolete ToDo Item? |