Re: PostgreSQL as a local in-memory cache

Поиск
Список
Период
Сортировка
От Jonathan Gardner
Тема Re: PostgreSQL as a local in-memory cache
Дата
Msg-id AANLkTilVMJK-XpFpTNltc0OED-q8cMlGCvh7Wy8A_mhq@mail.gmail.com
обсуждение исходный текст
Ответ на Re: PostgreSQL as a local in-memory cache  (Josh Berkus <josh@agliodbs.com>)
Ответы Re: PostgreSQL as a local in-memory cache  (Balkrishna Sharma <b_ki@hotmail.com>)
Список pgsql-performance
On Wed, Jun 16, 2010 at 12:00 PM, Josh Berkus <josh@agliodbs.com> wrote:
>
>> * fsync=off => 5,100
>> * fsync=off and synchronous_commit=off => 5,500
>
> Now, this *is* interesting ... why should synch_commit make a difference
> if fsync is off?
>
> Anyone have any ideas?
>

I may have stumbled upon this by my ignorance, but I thought I read
that synchronous_commit controlled whether it tries to line up commits
or has a more free-for-all that may cause some intermediate weirdness.

--
Jonathan Gardner
jgardner@jonathangardner.net

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

Предыдущее
От: Jonathan Gardner
Дата:
Сообщение: Re: PostgreSQL as a local in-memory cache
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Confirm calculus