| From: | Simon Riggs <simon(at)2ndquadrant(dot)com> |
|---|---|
| To: | Bernd Helmle <mailings(at)oopsware(dot)de> |
| Cc: | mfatticcioni(at)mbigroup(dot)it, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: DRBD and Postgres: how to improve the perfomance? |
| Date: | 2007-09-08 06:28:24 |
| Message-ID: | 1189232904.4281.19.camel@ebony.site |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)2ndquadrant(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dimitri | 2007-09-08 08:00:22 | Re: optimize query with a maximum(date) extraction |
| Previous Message | Bernd Helmle | 2007-09-07 21:54:12 | Re: DRBD and Postgres: how to improve the perfomance? |