Hi, I have recently had to change our nightly jobs from running vacuum full, as it has caused problems for us. Upon doing more reading on this topic, I understand that vacuum full needs explicit locks on the entire db and explicit locking conflicts with all other locks. But this has bought me to the question of what exactly is the difference between vacuum and vacuum full. If both give back free space to the disk, then why have vacuum full. Thank you. Radhika -- It is all a matter of perspective. You choose your view by choosing where to stand. --Larry Wall ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
