Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?

Поиск
Список
Период
Сортировка
Искать
От
Josh Berkus
Тема
Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?
Дата
Msg-id
4CD4800D.5050504@agliodbs.com
Ответ на
Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1? (Greg Smith)
Список
Дерево обсуждения
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> 

> Fair enough; I'm so used to bumping wal_buffers up to 16MB nowadays that
> I forget sometimes that people actually run with the default where this
> becomes an important consideration.

Do you have any testing in favor of 16mb vs. lower/higher?

-- 
                                  -- Josh Berkus
                                     PostgreSQL Experts Inc.
                                     http://www.pgexperts.com
В списке pgsql-performance по дате отправления
Предыдущее
От: Greg Smith
Дата:
Следующее
От: Josh Berkus
Дата:
FAQ