Re: Unnecessary delay in streaming replication due to replay lag

Asim Praveen <pasim@vmware.com>

From: Asim Praveen <pasim@vmware.com>

To: Masahiko Sawada <masahiko.sawada@2ndquadrant.com>

Cc: PostgreSQL mailing lists <pgsql-hackers@postgresql.org>, Michael Paquier <michael@paquier.xyz>, "Hao Wu (Pivotal)" <hawu@pivotal.io>

Date: 2020-08-10T08:53:34Z

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 →

Generate GUC tables from .dat file
- 63599896545c 19 (unreleased) cited
Skip WAL recycling and preallocation during archive recovery.
- cc2c7d65fc27 15.0 cited
Fix scenario where streaming standby gets stuck at a continuation record.
- 066871980183 11.0 cited

Attachments

v3-0001-Start-WAL-receiver-before-startup-process-replays.patch (application/octet-stream) patch v3-0001


> On 10-Aug-2020, at 12:27 PM, Masahiko Sawada <masahiko.sawada@2ndquadrant.com> wrote:
> 
> The patch can be applied cleanly to the current HEAD but I got the
> error on building the code with this patch:
> 
> xlog.c: In function 'StartupXLOG':
> xlog.c:7315:6: error: too few arguments to function 'RequestXLogStreaming'
> 7315 |      RequestXLogStreaming(ThisTimeLineID,
>      |      ^~~~~~~~~~~~~~~~~~~~
> In file included from xlog.c:59:
> ../../../../src/include/replication/walreceiver.h:463:13: note: declared here
>  463 | extern void RequestXLogStreaming(TimeLineID tli, XLogRecPtr recptr,
>      |             ^~~~~~~~~~~~~~~~~~~~
> 
> cfbot also complaints this.
> 
> Could you please update the patch?
> 

Thank you for trying the patch and apologies for the compiler error.  I missed adding a hunk earlier, it should be fixed in the version attached here.