On Thu, Jun 19, 2014 at 1:59 PM, M Tarkeshwar Rao <
m.tarkeshwar@ericsson.com> wrote:
> Hi,
>
> Insert query hangs what could be the reason. Is there any way to find out?
> Any timeout feature there with query which can be set at client or server
> end?
>
>
It might be due to concurrent primary key/unique key modifications. Try to
enable the log_lock_waits in postgresql.conf, which gives you more locks
information.
Regards,
Dinesh
manojadinesh.blogspot.com
> Regards
> Tarkeshwar
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>