Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?

Поиск
Список
Период
Сортировка
Искать
От
Tom Lane
Тема
Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?
Дата
Msg-id
27402.1289241634@sss.pgh.pa.us
Ответ на
Список
Дерево обсуждения
Defaulting wal_sync_method to fdatasync on Linux for 9.1? Marti Raudsepp <marti@juffo.org>
Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1? Greg Smith <greg@2ndquadrant.com>
Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1? Andres Freund <andres@anarazel.de>
Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1? Greg Smith <greg@2ndquadrant.com>
Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1? Andres Freund <andres@anarazel.de>
Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1? Josh Berkus <josh@agliodbs.com>
Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1? "Pierre C" <lists@peufeu.com>
Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1? Marti Raudsepp <marti@juffo.org>
Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1? Greg Smith <greg@2ndquadrant.com>
Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1? Marti Raudsepp <marti@juffo.org>
Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1? Greg Smith <greg@2ndquadrant.com>
Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1? Andres Freund <andres@anarazel.de>
Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1? Greg Smith <greg@2ndquadrant.com>
Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1? Marti Raudsepp <marti@juffo.org>
Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1? Marti Raudsepp <marti@juffo.org>
Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1? Scott Carey <scott@richrelevance.com>
Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1? Tom Lane <tgl@sss.pgh.pa.us>
Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1? Marti Raudsepp <marti@juffo.org>
Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1? Tom Lane <tgl@sss.pgh.pa.us>
Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1? Marti Raudsepp <marti@juffo.org>
Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1? Greg Smith <greg@2ndquadrant.com>
Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1? Andres Freund <andres@anarazel.de>
Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1? Greg Smith <greg@2ndquadrant.com>
Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1? Scott Carey <scott@richrelevance.com>
Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1? Greg Smith <greg@2ndquadrant.com>
Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1? Scott Carey <scott@richrelevance.com>
Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1? Jon Nelson <jnelson+pgsql@jamponi.net>
Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1? Greg Smith <greg@2ndquadrant.com>
Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1? Josh Berkus <josh@agliodbs.com>
Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1? Mladen Gogala <mladen.gogala@vmsinfo.com>
Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1? Scott Carey <scott@richrelevance.com>
Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1? Tom Lane <tgl@sss.pgh.pa.us>
Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1? Andres Freund <andres@anarazel.de>
Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1? Tom Lane <tgl@sss.pgh.pa.us>
Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1? Andres Freund <andres@anarazel.de>
Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1? Tom Lane <tgl@sss.pgh.pa.us>
Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1? Tom Lane <tgl@sss.pgh.pa.us>
Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1? Andres Freund <andres@anarazel.de>
Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1? Josh Berkus <josh@agliodbs.com>
Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1? Tom Lane <tgl@sss.pgh.pa.us>
Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1? Jignesh Shah <jkshah@gmail.com>
Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1? Marti Raudsepp <marti@juffo.org>
Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1? Robert Haas <robertmhaas@gmail.com>
Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1? Robert Haas <robertmhaas@gmail.com>
Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1? Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1? Marti Raudsepp <marti@juffo.org>
Scott Carey  writes:
> No matter how you slice it, the default on Linux is implicitly changing and the choice is to either:
>  * Return the default to fdatasync
>  * Let it implicitly change to O_DSYNC

> The latter choice is the one that requires testing to prove that it is the proper and preferred default from the performance and data reliability POV.

And, in fact, the game plan is to do that testing and see which default
we want.  I think it's premature to argue further about this until we
have some test results.

			regards, tom lane
В списке pgsql-performance по дате отправления
От: Scott Carey
Дата:
От: Pierre C
Дата:
Сообщение: Re: Select * is very slow
FAQ