Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 497769F9A3D for ; Tue, 2 Oct 2007 22:46:09 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 28795-04 for ; Tue, 2 Oct 2007 22:45:57 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.169]) by postgresql.org (Postfix) with ESMTP id DC8589F9A0D for ; Tue, 2 Oct 2007 22:46:03 -0300 (ADT) Received: by ug-out-1314.google.com with SMTP id j3so42233ugf for ; Tue, 02 Oct 2007 18:46:01 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; bh=KTYuZGOuiFHIUq/atHNFCJp+pn43p8D+X7ymQlwAOhE=; b=RtfwhW2Nz0N8M16ICUnpo2j+Q8Y8N+wxdfWCY11MJCNXAu6zFkDskiOx7QuMbuPNTZyzo633yRS2/bAbXmF9pU9rokRdYXOPkW7Gb8UCai78TrU7BtYBvbnUdZXaFsbWK9vV9txJPLcFSTIFdx03TJzgT+F4Jmn7/qDXVNN2cMA= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=FFL7xVeN+U27z4TzqSqj0wsRwjXzul4Ac8UTbErrkBx8oqfTULbE7HxugvIs3cdr/j0qAR2wgL175g9EAHyTFWOWFJIp6fn4Tgm21VM7Hhk8prN5dIOqy/qlvYJOH7APWsxhmUX2V67yYeBikv/GrRA4Bo+ZRUkBJmyZjl4TjYA= Received: by 10.67.16.5 with SMTP id t5mr1824438ugi.1191375938033; Tue, 02 Oct 2007 18:45:38 -0700 (PDT) Received: by 10.67.98.4 with HTTP; Tue, 2 Oct 2007 18:45:37 -0700 (PDT) Message-ID: Date: Tue, 2 Oct 2007 21:45:37 -0400 From: "Radhika S" To: pgsql-performance@postgresql.org Subject: Difference between Vacuum and Vacuum full MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/13 X-Sequence-Number: 27035 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