From: Radhika S <radhika.sambamurti@gmail.com>
To: pgsql-performance@postgresql.org
Subject: Difference between Vacuum and Vacuum full
Date: Tue, 2 Oct 2007 21:45:37 -0400
Message-ID: <fe27bfd40710021845r59796586t8f9e672d0f4142d3@mail.gmail.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: radhika.sambamurti@gmail.com
Subject: Re: Difference between Vacuum and Vacuum full
In-Reply-To: <fe27bfd40710021845r59796586t8f9e672d0f4142d3@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox