Re: Parallelize stream replication process

2020-09-17 Thread Li Japin
Thanks for your advice! This help me a lot. > On Sep 17, 2020, at 9:18 PM, Jakub Wartak wrote: > > Li Japin wrote: > >> If we can improve the efficiency of replay, then we can shorten the database >> recovery time (streaming replication or database crash recovery). > (..) >> For streaming

Re: Parallelize stream replication process

2020-09-17 Thread Jakub Wartak
Li Japin wrote: > If we can improve the efficiency of replay, then we can shorten the database > recovery time (streaming replication or database crash recovery). (..) > For streaming replication, we may need to improve the transmission of WAL > logs to improve the entire recovery process. >

Re: Parallelize stream replication process

2020-09-16 Thread Asim Praveen
> On 16-Sep-2020, at 8:32 AM, Li Japin wrote: > > Thanks for clarifying the questions! > >> On Sep 15, 2020, at 12:41 PM, Bharath Rupireddy >> wrote: >> >> I think we must ask few questions: >> >> 1. What's the major gain we get out of this? Is it that the time to >> stream gets reduced

Re: Parallelize stream replication process

2020-09-15 Thread Paul Guo
> On Sep 16, 2020, at 11:15 AM, Li Japin wrote: > > > >> On Sep 15, 2020, at 3:41 PM, Fujii Masao wrote: >> >> >> >> On 2020/09/15 13:41, Bharath Rupireddy wrote: >>> On Tue, Sep 15, 2020 at 9:27 AM Li Japin wrote: For now, postgres use single process to send, receive and

Re: Parallelize stream replication process

2020-09-15 Thread Li Japin
> On Sep 15, 2020, at 3:41 PM, Fujii Masao wrote: > > > > On 2020/09/15 13:41, Bharath Rupireddy wrote: >> On Tue, Sep 15, 2020 at 9:27 AM Li Japin wrote: >>> >>> For now, postgres use single process to send, receive and replay the WAL >>> when we use stream replication, >>> is there any

Re: Parallelize stream replication process

2020-09-15 Thread Li Japin
Thanks for clarifying the questions! > On Sep 15, 2020, at 12:41 PM, Bharath Rupireddy > wrote: > > On Tue, Sep 15, 2020 at 9:27 AM Li Japin wrote: >> >> For now, postgres use single process to send, receive and replay the WAL >> when we use stream replication, >> is there any point to

Re: Parallelize stream replication process

2020-09-15 Thread Fujii Masao
On 2020/09/15 13:41, Bharath Rupireddy wrote: On Tue, Sep 15, 2020 at 9:27 AM Li Japin wrote: For now, postgres use single process to send, receive and replay the WAL when we use stream replication, is there any point to parallelize this process? If it does, how do we start? Any

Re: Parallelize stream replication process

2020-09-14 Thread Bharath Rupireddy
On Tue, Sep 15, 2020 at 9:27 AM Li Japin wrote: > > For now, postgres use single process to send, receive and replay the WAL when > we use stream replication, > is there any point to parallelize this process? If it does, how do we start? > > Any thoughts? > I think we must ask few questions:

Parallelize stream replication process

2020-09-14 Thread Li Japin
Hi, hackers For now, postgres use single process to send, receive and replay the WAL when we use stream replication, is there any point to parallelize this process? If it does, how do we start? Any thoughts? Best regards Japin Li