Re: test: avoid redundant standby catchup in 049_wait_for_lsn - Mailing list pgsql-hackers

From Jobin Augustine
Subject Re: test: avoid redundant standby catchup in 049_wait_for_lsn
Date
Msg-id CAEpZXfcWKayYHrFc=MKkk6nHTGeFZ6Gi3Z0OuAEJACU0P=0Mew@mail.gmail.com
Whole thread
In response to Re: test: avoid redundant standby catchup in 049_wait_for_lsn  (Xuneng Zhou <xunengzhou@gmail.com>)
Responses Re: test: avoid redundant standby catchup in 049_wait_for_lsn
List pgsql-hackers
Hi Xuneng,


Interestingly, is this a pressure test? Can you please elaborate a bit more on how the application tests it? 
It was a custom coded application in Rust designed to demonstrate how this feature can reduce connections in the connection pool (deadpool of Rust with 16 connections in the pool), Because primary can commit asynchronously and release the connection back to pool and then wait for standby. I don't mind sharing the code, if that helps.
 
 
A client side workaround similar to the following is a temporary solution for me for my tests:
...

I think we better fix the page/segment header issue on the server side. 

Agree, +1
We cannot expect every application to impliment workaround after documenting the known problem 
Thank you,
Jobin.

pgsql-hackers by date:

Previous
From: shihao zhong
Date:
Subject: Two fixes for parallel query cleanup: DSM detach order and a stray statement timeout
Next
From: Paul Kim
Date:
Subject: Re: REVOKE's CASCADE protection doesn't work with INHERITed table owners