| From: | Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
|---|---|
| To: | "Dhruv Shukla *EXTERN*" <dhruvshukla82(at)gmail(dot)com>, "jayknowsunix(at)gmail(dot)com" <jayknowsunix(at)gmail(dot)com> |
| Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Problems with PG 9.3 |
| Date: | 2014-08-25 06:54:06 |
| Message-ID: | A737B7A37273E048B164557ADEF4A58B17D2CB2C@ntex2010i.host.magwien.gv.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sanket Mehta | 2014-08-25 08:34:16 | Re: OF TYPE without SCHEMA specified in TABLE creation interface |
| Previous Message | Emmanuel Massawe | 2014-08-23 09:04:41 | Job Opportunity. |