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

Jaime Casanova <jaime@2ndquadrant.com>

From: Jaime Casanova <jaime@2ndquadrant.com>

To: Simon Riggs <simon@2ndquadrant.com>

Cc: pgsql-committers@postgresql.org

Date: 2012-01-24T20:35:22Z

Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Add new replication mode synchronous_commit = 'write'.
- 443b4821f164 9.2.0 cited

On Tue, Jan 24, 2012 at 3:22 PM, Simon Riggs <simon@2ndquadrant.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