Postgres Pro
Downloads
Home   >   mailing lists

Re: Proposal: "Causal reads" mode for load balancing reads without stale data - Mailing list pgsql-hackers

From Robert Haas
Subject Re: Proposal: "Causal reads" mode for load balancing reads without stale data
Date
Msg-id CA+TgmoZgSH3v1Cu2nLb27=JU_4RtBwpAM548VtkVWR5PvqMgwg@mail.gmail.com
Whole thread Raw
In response to Re: Proposal: "Causal reads" mode for load balancing reads without stale data  (Thomas Munro <thomas.munro@enterprisedb.com>)
Responses Re: Proposal: "Causal reads" mode for load balancing reads without stale data
List pgsql-hackers
Tree view 
On Wed, Mar 23, 2016 at 7:34 AM, Thomas Munro
<thomas.munro@enterprisedb.com> wrote:
> synchronous_commit    TPS
> ==================== ====
> off                  9234
> local                1223
> remote_write          907
> on                    587
> remote_apply          555
>
> synchronous_commit    TPS
> ==================== ====
> off                  3937
> local                1984
> remote_write         1701
> on                   1373
> remote_apply         1349

Hmm, so "remote_apply" is barely more expensive than "on".  That's encouraging.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

pgsql-hackers by date:

Previous
From: Thomas Munro
Date:
Subject: Re: Proposal: "Causal reads" mode for load balancing reads without stale data
Next
From: Petr Jelinek
Date:
Subject: Re: VS 2015 support in src/tools/msvc