Re: [HACKERS] synchronous_commit = apply

2015-09-18 Thread Thomas Munro
On Fri, Sep 18, 2015 at 7:06 PM, Kyotaro HORIGUCHI wrote: > Hello, I have some random comments. Thanks for the feedback! I have fixed several of the things that you found in the attached new version -- see comments inline below. However, I now know that Simon has a better patch in development to

Re: [HACKERS] synchronous_commit = apply

2015-09-18 Thread Kyotaro HORIGUCHI
Hello, I have some random comments. At Wed, 16 Sep 2015 23:07:03 +1200, Thomas Munro wrote in > On Tue, Sep 8, 2015 at 1:11 AM, Thomas Munro > wrote: > > > On Thu, Sep 3, 2015 at 12:02 AM, Fujii Masao > > wrote: > > Hmm. So maybe commit records could have a flag saying 'someone is waiting

Re: [HACKERS] synchronous_commit = apply

2015-09-16 Thread Thomas Munro
On Thu, Sep 17, 2015 at 12:50 AM, Simon Riggs wrote: > On 1 September 2015 at 20:25, Thomas Munro > wrote: >> The next problem is that the master can be waiting quite a long time for a >> reply from the remote walreceiver containing the desired apply LSN: in the >> best case it learns of apply pr

Re: [HACKERS] synchronous_commit = apply

2015-09-16 Thread Simon Riggs
On 1 September 2015 at 20:25, Thomas Munro wrote: > Do you think it's reasonable to want to COMMIT a particular transaction on > a master node, and then immediately run a read-only query on a hot standby > node that is guaranteed to see that transaction? > Yes, that is reasonable and we've been

Re: [HACKERS] synchronous_commit = apply

2015-09-16 Thread Thomas Munro
On Tue, Sep 8, 2015 at 1:11 AM, Thomas Munro wrote: > On Thu, Sep 3, 2015 at 12:02 AM, Fujii Masao > wrote: >> >> One idea is to change the standby so that it manages the locations >> that the backends in "apply" mode are waiting for in the master, >> and to make the startup process wake the wa

Re: [HACKERS] synchronous_commit = apply

2015-09-07 Thread Thomas Munro
[Combining replies to emails from different authors into one message] On Wed, Sep 2, 2015 at 2:21 PM, Jaime Casanova < jaime.casan...@2ndquadrant.com> wrote: > On 1 September 2015 at 20:25, Thomas Munro > wrote: > As a quick weekend learning exercise/hack I recently went looking into how > > we

Re: [HACKERS] synchronous_commit = apply

2015-09-02 Thread Robert Haas
On Tue, Sep 1, 2015 at 9:25 PM, Thomas Munro wrote: > The next problem is that the master can be waiting quite a long time for a > reply from the remote walreceiver containing the desired apply LSN: in the > best case it learns of apply progress from replies to subsequent unrelated > records (whic

Re: [HACKERS] synchronous_commit = apply

2015-09-02 Thread Fujii Masao
On Wed, Sep 2, 2015 at 10:25 AM, Thomas Munro wrote: > Hi > > Do you think it's reasonable to want to COMMIT a particular transaction on a > master node, and then immediately run a read-only query on a hot standby > node that is guaranteed to see that transaction? > > A friend of mine who works wi

Re: [HACKERS] synchronous_commit = apply

2015-09-01 Thread Jaime Casanova
On 1 September 2015 at 20:25, Thomas Munro wrote: > Hi > > Do you think it's reasonable to want to COMMIT a particular transaction on a > master node, and then immediately run a read-only query on a hot standby > node that is guaranteed to see that transaction? > well, that is important to make l