From: | shveta malik <shveta(dot)malik(at)gmail(dot)com> |
---|---|
To: | "Drouvot, Bertrand" <bertranddrouvot(dot)pg(at)gmail(dot)com>, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> |
Cc: | "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com>, Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com>, Peter Eisentraut <peter(dot)eisentraut(at)enterprisedb(dot)com>, Bruce Momjian <bruce(at)momjian(dot)us>, Ashutosh Sharma <ashu(dot)coek88(at)gmail(dot)com>, Andres Freund <andres(at)anarazel(dot)de>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, Ajin Cherian <itsajin(at)gmail(dot)com>, Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>, Peter Smith <smithpb2250(at)gmail(dot)com>, shveta malik <shveta(dot)malik(at)gmail(dot)com> |
Subject: | Re: Synchronizing slots from primary to standby |
Date: | 2023-09-27 11:55:59 |
Message-ID: | CAJpy0uCmAcKnhtKqUctHCxhULMV4Thz1=Dz5ah-y6WO8x6f41g@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
PFA v20. The changes are:
1) The launcher now checks hot_standby_feedback (along with presence
of physical slot) before launching slot-sync workers and skips the
sync if it is off.
2) Other validity checks (for primary_slot_name, dbname in
primary_conn_info etc) are now moved to the launcher before we even
launch slot-sync workers. This will fix frequent WARNING msg coming in
log file as reported by Bertrand.
3) Now we stop all the slot-sync workers in case any of the related
GUCs has changed and then relaunch these in next sync-cycle as per new
values and after performing validity checks again.
4) This patch also fixes few bugs in wait_for_primary_slot_catchup():
4.1) This function was not coming out of wait gracefully on standby's
promotion, it is fixed now.
4.2) The checks to start the wait were not correct. These have been fixed now
4.3) If the slot (on which we are waiting) is invalidated on primary
meanwhile, this function was not handling that scenario and was not
aborting the wait. Handled now.
5) Addressed most of the comments(dated Sep25) given by Kruoda-san in
patch 0001.
First 4 changes are in patch002 while last one is in patch001.
thanks
Shveta
Attachment | Content-Type | Size |
---|---|---|
v20-0001-Allow-logical-walsenders-to-wait-for-physical-st.patch | application/octet-stream | 25.8 KB |
v20-0002-Add-logical-slot-sync-capability-to-physical-sta.patch | application/octet-stream | 108.4 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Étienne BERSAC | 2023-09-27 11:57:50 | Re: logfmt and application_context |
Previous Message | Amit Langote | 2023-09-27 11:52:29 | Re: Memory consumed by child SpecialJoinInfo in partitionwise join planning |