database load at times, because it happens 3-4 times out of every 4000
transactions.
pg_stat doesn't show any locks at the moment, but might not reflect the actual
scenario as currently the transactions are working fine.
Regards,
Vishal Gupta - 9910991635
- Original Message -
Problem: Function call typically takes 2-3 millisecond but at times exceeding
2-3 Minutes.
=
>From the DB logs it seems when multiple processes are trying to execute the
>function ,
execution takes sequentially rather than parallel, which mea
