Hi,
I am facing issue with postgresql 11.17 version.
When I use normal select it executes within 15 seconds.
When use same query with begin; cursor "sql1" hold for select....
Fetch 100 to "sql1" it takes 3 minutes and sometime not executing even in 10 minutes. And I need to kill it.
What could be the root cause. And how can we over one form this.