Re: Running PostgreSQL as fast as possible no matter the consequences

Поиск
Список
Период
Сортировка
От Thom Brown
Тема Re: Running PostgreSQL as fast as possible no matter the consequences
Дата
Msg-id AANLkTikzrFyQMtEMAu0ok1mrvy5D_LTSTDs7gmB0nMmD@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Running PostgreSQL as fast as possible no matter the consequences  (Thom Brown <thom@linux.com>)
Список pgsql-performance
Дерево обсуждения
On 5 November 2010 11:14, Thom Brown <thom@linux.com> wrote:
On 5 November 2010 10:59, A B <gentosaker@gmail.com> wrote:
Hi there.

If you just wanted PostgreSQL to go as fast as possible WITHOUT any
care for your data (you accept 100% dataloss and datacorruption if any
error should occur), what settings should you use then?


Turn off fsync and full_page_writes (i.e. running with scissors).

Also depends on what you mean by "as fast as possible".  Fast at doing what?  Bulk inserts, selecting from massive tables?


Oh, and turn synchronous_commit off too.

--
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Linux user: #516935

В списке pgsql-performance по дате отправления:

Предыдущее
От: Thom Brown
Дата:
Сообщение: Re: Running PostgreSQL as fast as possible no matter the consequences
Следующее
От: Guillaume Cottenceau
Дата:
Сообщение: Re: Running PostgreSQL as fast as possible no matter the consequences