"dghundt@xxxxxxxxxxx" <dghundt@xxxxxxxxxxx> writes: > Postgres backsup the data and 95% of the time sticks at this table and cpu activity drops from 40-60% to about zero. I can stay there for hours before I just have to stop the attempt. Have you looked into pg_locks to see if something is holding an exclusive lock on that table? Have you checked to see if there's still disk activity? regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
