From: | "Shridhar Polas" <shridharpolas(at)gmail(dot)com> |
---|---|
To: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | Deadlock like scenario |
Date: | 2011-11-11 03:04:47 |
Message-ID: | 004b01cca01e$ae297f80$0a7c7e80$@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi,
I am experience the problem where locks acquired by postgres are NOT getting
released.
The use case is something like:-
. There is a table let's say "A" and the trigger is created on this
table let say "A_TRIGGER".
. The trigger captures the data change happens in table A into table
B.
. There would be a huge insert, update, delete on table A, the side
effect of it table B also get updated very frequently.
. There is periodic job that runs every midnight to do full vacuum
and re-indexing on table B (but NOT on table A).
. It has been found that the queries are hanging and never completes
when there are some operation on table A.
Can someone please help me out to resolve this problem. If someone need more
information on this then please let me know.
Thanks in advance,
Shridhar
From | Date | Subject | |
---|---|---|---|
Next Message | Craig Ringer | 2011-11-11 03:06:38 | Re: lost tablespace |
Previous Message | Craig Ringer | 2011-11-11 02:54:10 | Re: error log, tablespace, wal files |