Re: tuning postgresql writes to disk

Поиск
Список
Период
Сортировка
От Vick Khera
Тема Re: tuning postgresql writes to disk
Дата
Msg-id AANLkTi=sjSBpKwDLPpsAZ0oFDu2GPaSAjSvWio15gxuC@mail.gmail.com
обсуждение исходный текст
Ответ на tuning postgresql writes to disk  (Vinubalaji Gopal <vinubalaji@gmail.com>)
Ответы Re: tuning postgresql writes to disk  (Vinubalaji Gopal <vinubalaji@gmail.com>)
Список pgsql-general
On Thu, Feb 3, 2011 at 7:08 PM, Vinubalaji Gopal <vinubalaji@gmail.com> wrote:
> already does this.  I looked at the WAL parameters and the new async
> commit  but not sure if I am looking at the right place. Say i have 10
> clients connecting and each client is inserting a record. I want to
>

You want the async commit.  If you can detect and re-execute "lost"
transactions, it gives you the best of everything: defer disk I/O and
transaction boundaries are honored so you never have inconsistent data
after crash recovery.

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

Предыдущее
От: Andre Lopes
Дата:
Сообщение: Slow Inserts, two different scenarios.
Следующее
От: Vick Khera
Дата:
Сообщение: Re: Directing Partitioned Table Searches