Re: INVALID index while concurrent indexing in progress?

2022-05-21 Thread Rajakavitha Kodhandapani
>
>
> > Anyway, I pushed the patch.  I appreciate your willingness to
> > collaborate and look forward to your future participation, for sure.


Thank you Laurenz and  Alvaro.

Regards,
Rajie

On Fri, May 20, 2022 at 3:55 PM Laurenz Albe 
wrote:

> On Fri, 2022-05-20 at 10:30 +0200, Alvaro Herrera wrote:
> >
> > Anyway, I pushed the patch.  I appreciate your willingness to
> > collaborate and look forward to your future participation, for sure.
>
> Thanks!
>
> Laurenz Albe
>


about pg14 new parameter in_hot_standby

2022-05-21 Thread yanliang lei
in the pg14 
document(https://www.postgresql.org/docs/14/runtime-config-preset.html)

in_hot_standby parameter:

Reports whether the server is currently in hot standby mode. 

When this is on, all transactions are forced to be read-only. 

Within a session, this can change only if the server is promoted to be primary. 
See Section 27.4 for more information.




"Within a session, this can change only if the server is promoted to be 
primary"--- I can not understand this statement.




I think document will tell us:

when the postgresql cluster is in the standby database role, the standby 
database parameter in_hot_standby value will change to on,and this 
in_hot_standby parameter can not been modified in the session.




I do not know what I say is correct or not.