Dhruv Shukla wrote: > Right now we are doing is only logs where on each statement for a sql function we are raising an info. > > This way we know which step its getting stuck. Today it got stuck on the insert statement. > > And we ran the same SQL function after killing the process, it ran normal without any issues. That sounds a lot like locking problems. Examine pg_locks when a process gets stuck an see if it is waiting for a lock and who is holding the lock. Yours, Laurenz Albe -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
