Bryan Field-Elliot <bryan_lists@xxxxxxxxxxx> schrieb: > Is there any mechanism for running pg_dump with a lower priority? I don't mind > if the backup takes two hours instead of half an hour, as long as other > processes were getting their fair share of cycles. You can use 'nice', see see the man-page. Andreas -- Really, I'm not out to destroy Microsoft. That will just be a completely unintentional side effect. (Linus Torvalds) Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889° ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match