Re: question on streaming replication

2018-06-15 Thread Amit Kapila
ffective. > Please suggest the needful. > As mentioned above, I suggest asking only PostgreSQL related questions on these mailing lists. -- With Regards, Amit Kapila. EnterpriseDB: http://www.enterprisedb.com

Re: Slow planning time for simple query

2018-06-16 Thread Amit Kapila
as a different value on standby, then it is possible that the decision whether a particular item is dead differs on master and standby. > (I wonder though why, if you executed the same query on the master, > its setting of the index-entry-is-dead bits didn't propagate to the >

Re: Slow planning time for simple query

2018-06-16 Thread Amit Kapila
ctual_variable_range execution that considerately slows down planning. > > Is it bug or restriction of implementation or misconfiguration of > WAL/replication? > It is not a misconfiguration issue. -- With Regards, Amit Kapila. EnterpriseDB: http://www.enterprisedb.com

Re: Behaviour of failed Primary

2020-05-21 Thread Amit Kapila
standby role? It would be of great help, if you can direct me to any > references details. Thank you, upfront. > I think pg_rewind can help in such situations. See the docs of pg_rewind [1]. [1] - https://www.postgresql.org/docs/devel/app-pgrewind.html -- With Regards, Amit Kapila. EnterpriseDB: http://www.enterprisedb.com

Re: Logical replication issue after Postgresql upgrade from 13 to 14

2021-12-01 Thread Amit Kapila
fine with that. Feel free to propose a patch on -hackers. I can help in reviewing and improving the same. -- With Regards, Amit Kapila.