*** pgsql/doc/src/sgml/ref/vacuum.sgml 2008/12/11 18:16:18 1.54 --- pgsql/doc/src/sgml/ref/vacuum.sgml 2009/03/24 20:17:08 1.55 *************** *** 1,5 **** --- 1,5 ---- *************** VACUUM [ FULL ] [ FREEZE ] [ VERBOSE ] A *** 161,166 **** --- 161,173 ---- + For tables with GIN indexes, VACUUM (in + any form) also completes any pending index insertions, by moving pending + index entries to the appropriate places in the main GIN index + structure. See for details. + + + We recommend that active production databases be vacuumed frequently (at least nightly), in order to remove dead rows. After adding or deleting a large number