Ok thanks for the insights.
Do we need to do any config changes in the config file?
We have also configured Datadog agent at operating system level that checks postgresql activity it's has the pgpouncer.d config file that is unchanged after the migration. This might be the possible reason that it is throughing dead lock error.
Please through some insights on the above.
Thanks for the immediate help.
Regards,
Wasim
On Thu, 15 Aug, 2024, 9:01 am David G. Johnston, <david.g.johnston@xxxxxxxxx> wrote:
On Wednesday, August 14, 2024, Wasim Devale <wasimd60@xxxxxxxxx> wrote:So it's not a postgresql issue. It's from the application side correct?
That’s the assumption. The vast majority of locks happen because the “application” executed SQL commands.David J.
