Re: Maximum Performance Follow-up Question

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Maximum Performance Follow-up Question
Дата
Msg-id 25432.1011972211@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Maximum Performance Follow-up Question  (Radu-Adrian Popescu <radu.popescu@aldratech.com>)
Ответы Re: Maximum Performance Follow-up Question  ("Peter T. Brown" <peter@memeticsystems.com>)
Список pgsql-admin
Radu-Adrian Popescu <radu.popescu@aldratech.com> writes:
> I belive you should set
>     fsync=false
> in case you mainly select and do inserts rather rare.

No, that's a really horrid reason to turn off fsync.  A read-only
transaction never syncs and thus has no fsync penalty.  If update
performance isn't a serious problem for you, you may as well keep
fsync on and not have to worry about data loss in the case of a
system crash.

            regards, tom lane

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

Предыдущее
От: Stephan Szabo
Дата:
Сообщение: Re: Vacuum and Vacuum analyse
Следующее
От: "Zhang, Anna"
Дата:
Сообщение: Re: Increasing Shared Memory - on MacOS X