--- On Mon, 12/7/09, Tom Lane wrote:
Have you looked into pg_locks to see if it's blocked
waiting for a lock?
The TRUNCATE in particular would require exclusive lock on
the table, so it could be waiting for some other process
that's touched the table.
Thanks Tom - while pg_locks did not
A re-post, since I'm really stuck on this and could use some advice on how to
troubleshoot this...
I have an app that was previously using a large unpartitioned table with no
problems. I partitioned this table and am now experiencing intermittent hangs
when inserting data into the partitioned
Rob W digital_illumin...@yahoo.com writes:
A re-post, since I'm really stuck on this and could use some advice on how to
troubleshoot this...
Have you looked into pg_locks to see if it's blocked waiting for a lock?
The TRUNCATE in particular would require exclusive lock on the table,
so it
I have an app that was previously using a large unpartitioned table with no
problems. I partitioned this table and am now experiencing intermittent hangs
when inserting data into the partitioned table. The stored procedure that does
the insert seems to run to completion even when it 'hangs'.