Rob W <digital_illuminati@xxxxxxxxx> 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 other process that's touched the table. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
