Re: Postgres becoming slow, only full vacuum fixes it

Поиск
Список
Период
Сортировка
От Julien Cigar
Тема Re: Postgres becoming slow, only full vacuum fixes it
Дата
Msg-id 506057E7.5090008@ulb.ac.be
обсуждение исходный текст
Ответ на Re: Postgres becoming slow, only full vacuum fixes it  (Andres Freund <andres@2ndquadrant.com>)
Ответы Re: Postgres becoming slow, only full vacuum fixes it
Список pgsql-performance
On 09/24/2012 14:34, Andres Freund wrote:
> On Monday, September 24, 2012 02:21:09 PM Julien Cigar wrote:
>> 5) synchronous_commit = off should only be used if you have a
>> battery-backed write cache.
> Huh? Are you possibly confusing this with full_page_writes?

indeed...! sorry for that
(note that you still have a (very) small chance of loosing data with
synchronous_commit = off if your server crashes between two "commit chunks")

> Greetings,
>
> Andres


--
No trees were killed in the creation of this message.
However, many electrons were terribly inconvenienced.


Вложения

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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: Postgres becoming slow, only full vacuum fixes it
Следующее
От: Andres Freund
Дата:
Сообщение: Re: Postgres becoming slow, only full vacuum fixes it