Re: improve wals replay on secondary

In my case, I'm talking about creating a standby -> standby clone and then recover the wals . How can I run checkpoint in the secondary if it isnt up ? ‫בתאריך יום ד׳, 29 במאי 2019 ב-13:54 מאת ‪Nikolay Samokhvalov‬‏ <‪ samokhva...@gmail.com‬‏>:‬ > Hello Mariel, > > 1) Have you tried to run “CHECK

Re: improve wals replay on secondary

Hello Mariel, 1) Have you tried to run “CHECKPOINT;” on the standby to perform restartpoint explicitly? It is possible. 2) If we talk about streaming replication, do you use replication slots? If so, have you checked pg_replication_slots and pg_stat_replication? They can help to troubleshoot stre

Re: JIT in PostgreSQL 12 ?

On 5/29/19 10:02 AM, Tobias Gierke wrote: Browsing the PostgreSQL 12 release notes I noticed that JIT is now enabled by default. Having not followed PostgreSQL development closely - does this mean that compilation results are now getting cached and compilation is no longer executed separately f

Re: Sv: JIT in PostgreSQL 12 ?

På onsdag 29. mai 2019 kl. 11:13:10, skrev Tobias Gierke < tobias.gie...@code-sourcery.de >: Hi, På onsdag 29. mai 2019 kl. 10:02:50, skrev Tobias Gierke < tobias.gie...@code-sourcery.de >: Hi, Browsing the PostgreSQL

Re: Sv: JIT in PostgreSQL 12 ?

Hi, På onsdag 29. mai 2019 kl. 10:02:50, skrev Tobias Gierke mailto:tobias.gie...@code-sourcery.de>>: Hi, Browsing the PostgreSQL 12 release notes I noticed that JIT is now enabled by default. Having not followed PostgreSQL development closely - does this mean that compilat

Sv: JIT in PostgreSQL 12 ?

På onsdag 29. mai 2019 kl. 10:02:50, skrev Tobias Gierke < tobias.gie...@code-sourcery.de >: Hi, Browsing the PostgreSQL 12 release notes I noticed that JIT is now enabled by default. Having not followed PostgreSQL development closely - does this mean that

Re: improve wals replay on secondary

Is there any messages that indicates that the secondary replayed a specific wal ? "restored 0..." means that the restore_command succeeded but there isnt any proof that it replayed the wal. My theory regarding the issue : It seems, that my customer stopped the db 20 minutes after the clone ha

Re: improve wals replay on secondary

On 5/29/19 9:20 AM, Mariel Cherkassky wrote: > First of all thanks Fabio. > I think that I'm missing something :  > In the next questionI'm not talking about streaming replication,rather > on recovery :  > > 1.When the secondary get the wals from the primary it tries to replay > them correct ? 

JIT in PostgreSQL 12 ?

Hi, Browsing the PostgreSQL 12 release notes I noticed that JIT is now enabled by default. Having not followed PostgreSQL development closely - does this mean that compilation results are now getting cached and compilation is no longer executed separately for each worker thread in a parallel

Re: improve wals replay on secondary

First of all thanks Fabio. I think that I'm missing something : In the next questionI'm not talking about streaming replication,rather on recovery : 1.When the secondary get the wals from the primary it tries to replay them correct ? 2. By replaying it just go over the wal records and run them in