Re: Runaway Initial Table Syncs in Logical Replication?

2023-08-04 Thread Don Seiler
On Thu, Aug 3, 2023 at 9:12 PM Zhijie Hou (Fujitsu) wrote: > > Just to confirm, which subversion of PG15 are you using on the subscriber > side ? > Is it 15.3 ? I am confirming because I recall we fixed similar bug before > in commit [1]. > Yes. Specifically on the target/subscriber: # select v

Re: question on auto_explain

2023-08-04 Thread Karsten Hilbert
Am Fri, Aug 04, 2023 at 01:33:19PM +0800 schrieb Julien Rouhaud: > > explicit hint towards write query side effects. > > The docs says that it automatically shows the execution plans, not that it's > itself doing an EXPLAIN. Yep, so maybe _that_ point warrants being pointed out: that auto_explain

Re: PITR based recovery failing due to difference in max_connections

2023-08-04 Thread Kalit Inani
Hi, Thanks for the quick response. Regarding your questions, *Why did you do that?* This is our requirement and we are restoring this on another instance(destination instance) where are the 'max_connection' value should be less than that of the source instance(150 in our case). On Fri, Aug 4, 2023

Re: question on auto_explain

2023-08-04 Thread Frédéric Yhuel
On 8/4/23 07:33, Julien Rouhaud wrote: Now, there also seems to be some common misconception about how auto_explain is working, as it's not the first time that I hear people thinking or assuming that it's executing extra EXPLAIN commands. Maybe adding some extra clarification could help, mayb