On Sat, Nov 15, 2003 at 05:13:38AM -0800, George Essig wrote:
> VACUUM ANALYZE will reclaim disk space and update statistics used

Strictly speaking, it does not reclaim disk space.  It merely marks
it as available, assuming you have enough room in your free space
map.  VACUUM FULL reclaims disk space, i.e. it compacts the data
files and returns that space to the operating system.

Andrew Sullivan                         204-4141 Yonge Street
Afilias Canada                        Toronto, Ontario Canada
<[EMAIL PROTECTED]>                              M2P 2A8
                                         +1 416 646 3304 x110

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Reply via email to