"[EMAIL PROTECTED]" <[EMAIL PROTECTED]> 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