VACUUM(7)                        SQL Commands                        VACUUM(7)

NAME
       VACUUM - <?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?>


SYNOPSIS
       VACUUM [ FULL ] [ FREEZE ] [ VERBOSE ] [ table ]
       VACUUM [ FULL ] [ FREEZE ] [ VERBOSE ] ANALYZE [ table [ (column [, ...] ) ] ]


DESCRIPTION <?><?>
       VACUUM <?><?><?><?><?><?><?><?><?><?><?><?><?><?><?> <?><?><?><?>
       PostgreSQL <?><?><?><?> <?><?><?><?> DELETE <?><?><?><?><?><?> UPDATE
       <?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?>
       <?><?><?> VACUUM <?><?><?><?><?><?><?><?><?>
       <?><?><?><?><?><?><?><?><?><?><?><?> VACUUM<?>
       <?><?><?><?><?><?><?><?><?><?><?>

        <?><?><?><?><?><?><?>VACUUM <?><?><?><?><?><?><?><?><?><?><?><?>
       <?><?><?><?><?><?>VACUUM <?><?><?><?><?><?><?>

       VACUUM ANALYZE <?><?><?><?><?> VACUUM
       <?><?><?><?><?><?><?><?><?><?><?><?><?><?> ANALYZE<?>
       <?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?>
       ANALYZE [analyze(7)] <?><?><?><?><?><?><?><?><?><?><?><?><?>

        <?><?><?> VACUUM <?><?><?>FULL<?>
       <?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?>
       <?><?><?><?><?><?><?><?><?><?>VACUUM FULL
       <?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?>
       <?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?>

       FREEZE
       <?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?>"<?><?>(frozen)"<?>
       <?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?>
       <?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?>"<?><?>(frozen)"<?><?>
       <?><?><?><?><?><?><?> ID
       <?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?>
       <?><?><?><?><?><?> FREEZE
       <?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?>
       <?><?><?><?><?><?><?><?><?><?><?><?> <?><?><?><?><?><?><?><?><?> VACUUM
       <?><?><?><?><?><?><?> <?><?> Chapter 21 ``Routine Database
       Maintenance'' <?><?><?><?><?>

PARAMETERS <?><?>
       FULL
               <?><?>"<?><?>"<?><?><?><?><?><?><?><?><?><?><?><?><?><?><?>
              <?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?>

       FREEZE
               <?><?><?><?><?><?><?>"<?><?>"<?>

       VERBOSE
               <?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?>

       ANALYZE
               <?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?>

       table
               <?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?>

       column
               <?><?><?><?><?><?><?><?>/<?><?><?><?><?><?><?><?><?><?><?>/<?><?><?>

OUTPUTS <?><?>
        <?><?><?><?><?> VERBOSE<?>VACUUM <?><?><?><?><?><?><?>
       <?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?>

NOTES <?><?>
        <?><?><?><?><?><?><?>VACUUMM<?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?>
       <?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?>
       <?><?><?><?><?><?><?><?> VACUUM ANALYZE
       <?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?>
       PostgreSQL
       <?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?>

        <?><?><?><?><?><?><?><?><?> FULL
       <?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?>
       <?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?>VACUUM
       FULL  <?><?><?><?><?><?><?> VACUUM <?><?><?><?><?><?><?><?><?>

EXAMPLES <?><?>
        <?><?><?><?><?><?> regression
       <?><?><?><?><?><?><?><?><?><?><?><?><?><?> VACUUM<?><?><?><?><?><?>

       regression=# VACUUM VERBOSE ANALYZE onek;
       INFO:  vacuuming "public.onek"
       INFO:  index "onek_unique1" now contains 1000 tuples in 14 pages
       DETAIL:  3000 index tuples were removed.
       0 index pages have been deleted, 0 are currently reusable.
       CPU 0.01s/0.08u sec elapsed 0.18 sec.
       INFO:  index "onek_unique2" now contains 1000 tuples in 16 pages
       DETAIL:  3000 index tuples were removed.
       0 index pages have been deleted, 0 are currently reusable.
       CPU 0.00s/0.07u sec elapsed 0.23 sec.
       INFO:  index "onek_hundred" now contains 1000 tuples in 13 pages
       DETAIL:  3000 index tuples were removed.
       0 index pages have been deleted, 0 are currently reusable.
       CPU 0.01s/0.08u sec elapsed 0.17 sec.
       INFO:  index "onek_stringu1" now contains 1000 tuples in 48 pages
       DETAIL:  3000 index tuples were removed.
       0 index pages have been deleted, 0 are currently reusable.
       CPU 0.01s/0.09u sec elapsed 0.59 sec.
       INFO:  "onek": removed 3000 tuples in 108 pages
       DETAIL:  CPU 0.01s/0.06u sec elapsed 0.07 sec.
       INFO:  "onek": found 3000 removable, 1000 nonremovable tuples in 143 pages
       DETAIL:  0 dead tuples cannot be removed yet.
       There were 0 unused item pointers.
       0 pages are entirely empty.
       CPU 0.07s/0.39u sec elapsed 1.56 sec.
       INFO:  analyzing "public.onek"
       INFO:  "onek": 36 pages, 1000 rows sampled, 1000 estimated total rows
       VACUUM


COMPATIBILITY <?><?><?>
       SQL <?><?><?><?><?> VACUUM <?><?><?>

SEE ALSO <?><?>
       vacuumdb [vacuumdb(1)]


<?><?>
       Postgresql <?><?><?><?> <?><?><?> <laser@pgsqldb.org>

<?>
       <?><?><?><?><?><?><?><?><?> man <?><?><?><?><?><?><?><?>
       <?><?> man <?><?><?><?><?><?>https://github.com/man-pages-zh/manpages-
       zh

SQL - Language Statements         2003-11-02                         VACUUM(7)