Re: DRBD and Postgres: how to improve the perfomance?

Поиск
Список
Период
Сортировка
От Simon Riggs
Тема Re: DRBD and Postgres: how to improve the perfomance?
Дата
Msg-id 1189232904.4281.19.camel@ebony.site
обсуждение исходный текст
Ответ на Re: DRBD and Postgres: how to improve the perfomance?  (Bernd Helmle <mailings@oopsware.de>)
Ответы Re: DRBD and Postgres: how to improve the perfomance?  (Gregory Stark <stark@enterprisedb.com>)
Список pgsql-performance
On Fri, 2007-09-07 at 23:54 +0200, Bernd Helmle wrote:
> --On Freitag, September 07, 2007 20:00:16 +0100 Simon Riggs
> <simon@2ndquadrant.com> wrote:
>
> > On Fri, 2007-09-07 at 11:37 +0200, Maila Fatticcioni wrote:
> >
> >>  protocol C;
> >
> > Try protocol B instead.
>
> But that would have an impact on transaction safety, wouldn't it? It will
> return immediately after reaching the remote buffer cache and you can't be
> sure your data hits the remote disk.

You're right, but the distinction is a small one. What are the chances
of losing two independent servers within a few milliseconds of each
other?

If performance is an issue it is a particularly important distinction.

--
  Simon Riggs
  2ndQuadrant  http://www.2ndQuadrant.com


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

Предыдущее
От: Bernd Helmle
Дата:
Сообщение: Re: DRBD and Postgres: how to improve the perfomance?
Следующее
От: Dimitri
Дата:
Сообщение: Re: optimize query with a maximum(date) extraction