Difference between Vacuum and Vacuum full - Mailing list pgsql-performance

From Radhika S
Subject Difference between Vacuum and Vacuum full
Date
Msg-id fe27bfd40710021845r59796586t8f9e672d0f4142d3@mail.gmail.com
Whole thread Raw
Responses Re: Difference between Vacuum and Vacuum full
Re: Difference between Vacuum and Vacuum full
Re: Difference between Vacuum and Vacuum full
List pgsql-performance
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

pgsql-performance by date:

Previous
From: Greg Williamson
Date:
Subject: Re: Newbie question about degraded performance on delete statement.
Next
From: "Scott Marlowe"
Date:
Subject: Re: Difference between Vacuum and Vacuum full