Re: Insert query hangs what could be the reason

Поиск
Список
Период
Сортировка
От dinesh kumar
Тема Re: Insert query hangs what could be the reason
Дата
Msg-id CALnrH7oLJLYdREuw=pLpdw9JiTXqakepsEQtcWbpBZnrZ9dwtA@mail.gmail.com
обсуждение исходный текст
Ответ на Insert query hangs what could be the reason  (M Tarkeshwar Rao <m.tarkeshwar.rao@ericsson.com>)
Список pgsql-general
Дерево обсуждения
On Thu, Jun 19, 2014 at 1:59 PM, M Tarkeshwar Rao <m.tarkeshwar.rao@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
Tarkeshwar


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

В списке pgsql-general по дате отправления:

Предыдущее
От: Oliver
Дата:
Сообщение: Re: Best backup strategy for production systems
Следующее
От: Khangelani Gama
Дата:
Сообщение: Re: pg_restore: custom archiver unexpected end of file , ERROR: missing data for column