Re: Synchronization levels in SR - Mailing list pgsql-hackers

From Florian Pflug
Subject Re: Synchronization levels in SR
Date
Msg-id 7CEC997C-A886-4A66-B74C-6C01D01E8876@phlo.org
Whole thread Raw
In response to Re: Synchronization levels in SR  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-hackers
On May 25, 2010, at 22:16 , Simon Riggs wrote:
> All of these issues show why I want to specify the synchronisation mode
> as a USERSET. That will allow us to specify more easily which parts of
> our application are important when the cluster is degraded and which
> data is so critical it must reach multiple servers.


Hm, but since flushing a important COMMIT to the slave(s) will also need to flush all previous (potentially
unimportant)COMMITs to the slave(s), isn't there a substantial chance of priority-inversion type problems there? 

Then again, if asynchronous_commit proved to be effective than so will this probably, so maybe my fear is unjustified.

best regards,
Florian Pflug



pgsql-hackers by date:

Previous
From: KaiGai Kohei
Date:
Subject: Re: ExecutorCheckPerms() hook
Next
From: Stephen Frost
Date:
Subject: Re: Fwd: Hiding data in postgresql