Skip site navigation (1) Skip section navigation (2)

Re: pgsql: Add new replication mode synchronous_commit = 'write'.

From: Jaime Casanova <jaime(at)2ndquadrant(dot)com>
To: Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc: pgsql-committers(at)postgresql(dot)org
Subject: Re: pgsql: Add new replication mode synchronous_commit = 'write'.
Date: 2012-01-24 20:35:22
Message-ID: CAJKUy5iCx2vm5ogMEm5eGTHjb45q-gvaSf0n+-o2X39HanE37g@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-committerspgsql-hackers
On Tue, Jan 24, 2012 at 3:22 PM, Simon Riggs <simon(at)2ndquadrant(dot)com> wrote:
> Add new replication mode synchronous_commit = 'write'.
> Replication occurs only to memory on standby, not to disk,
> so provides additional performance if user wishes to
> reduce durability level slightly. Adds concept of multiple
> independent sync rep queues.
>
> Fujii Masao and Simon Riggs
>

i guess, you should add the new value in postgresql.conf too.
just a question, why not add a flush value and make it behave like on?
actually sync rep is on in both cases and having the different names
makes more easy to unserstand what is happening.
i only want to keep on for compatibility but i wouldn't mind if we
remove it in favor of more descriptive names.

or there's any difference between on and flush that i'm failing to see?

-- 
Jaime Casanova         www.2ndQuadrant.com
Professional PostgreSQL: Soporte 24x7 y capacitación

In response to

Responses

pgsql-hackers by date

Next:From: Robert HaasDate: 2012-01-24 20:53:48
Subject: some longer, larger pgbench tests with various performance-related patches
Previous:From: Simon RiggsDate: 2012-01-24 20:28:25
Subject: Re: New replication mode: write

pgsql-committers by date

Next:From: Bruce MomjianDate: 2012-01-25 02:51:21
Subject: pgsql: Fix new SQL tablespace location function usage in pg_upgradeto
Previous:From: Simon RiggsDate: 2012-01-24 20:22:57
Subject: pgsql: Add new replication mode synchronous_commit = 'write'.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group