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
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
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
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
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
[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
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
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
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