Re: Sv: JIT in PostgreSQL 12 ?

2019-05-31 Thread Justin Pryzby
On Wed, May 29, 2019 at 10:48:19AM +0200, Andreas Joseph Krogh wrote: > På onsdag 29. mai 2019 kl. 10:02:50, skrev Tobias Gierke > > Hi, > > Browsing the PostgreSQL 12 release notes I noticed that JIT is now > enabled by default. Having not followed PostgreSQL development closely - > does thi

Re: improve wals replay on secondary

2019-05-31 Thread Fabio Pardi
On 5/29/19 10:39 AM, Mariel Cherkassky wrote: > 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. I believe that the message "restored log file..'

Re: Shortest offline window on database migration

2019-05-31 Thread Fabio Pardi
On 5/30/19 5:08 PM, Haroldo Kerry wrote: > Hello, > > We are migrating our PostgreSQL 9.6.10 database (with streaming > replication active) to a faster disk array. > We are using this opportunity to enable checksums, I would stay away from performing 2 big changes in one go. regards, fabio p