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 AANLkTik0FBaJuG0yOO6MqCsYNYrW3rz1K5Uv0R71GBf8@mail.gmail.com
обсуждение исходный текст
Ответ на Running PostgreSQL as fast as possible no matter the consequences  (A B <gentosaker@gmail.com>)
Ответы Re: Running PostgreSQL as fast as possible no matter the consequences  (Thom Brown <thom@linux.com>)
Re: Running PostgreSQL as fast as possible no matter the consequences  (A B <gentosaker@gmail.com>)
Список pgsql-performance
Дерево обсуждения
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?

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

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

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