--- On Mon, 12/7/09, Tom Lane 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 reveal
Rob W 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 could be waiting for some othe
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 t
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'. The
