Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

[doc patch] a slight VACUUM / VACUUM FULL doc improvement proposal


  • From: Guillaume Cottenceau <gc(at)mnc(dot)ch>
  • To: pgsql-performance(at)postgresql(dot)org
  • Subject: [doc patch] a slight VACUUM / VACUUM FULL doc improvement proposal
  • Date: 15 May 2007 18:43:50 +0200
  • Message-id: <87lkfqavg9.fsf@meuh.mnc.lan> <text/plain>

Dear all,

After some time spent better understanding how the VACUUM process
works, what problems we had in production and how to improve our
maintenance policy[1], I've come up with a little documentation
patch - basically, I think the documentation under estimates (or
sometimes misses) the benefit of VACUUM FULL for scans, and the
needs of VACUUM FULL if the routine VACUUM hasn't been done
properly since the database was put in production. Find the patch
against snapshot attached (text not filled, to ease reading). It
might help others in my situation in the future.

Attachment: pg_vacuum.patch
Description: Text Data

Ref: 
[1] http://archives.postgresql.org/pgsql-performance/2006-08/msg00419.php
    http://archives.postgresql.org/pgsql-performance/2007-05/msg00112.php

-- 
Guillaume Cottenceau, MNC Mobile News Channel SA, an Alcatel-Lucent Company
Av. de la Gare 10, 1003 Lausanne, Switzerland - direct +41 21 317 50 36


Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group