Re: Problems with PG 9.3

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