PostgreSQL

Скачать в pdf «PostgreSQL»


Usage


The following is an example from running VACUUM on a table in the regression database:


regressions vacuum verbose analyze onek;


NOTICE:    —Relation onek—


NOTICE:


Pages 98: Changed 25, Reapped 74, Empty 0, New 0;


Tup 1000: Vac 3000, Crash 0, UnUsed 0, MinLen 188, MaxLen 188; Re-using: Free/Avail. Space 586952/586952; EndEmpty/Avail. Pages 0/74. Elapsed 0/0 sec.


NOTICE:


Index onek —

stringul: Pages 28; Tuples 1000: Deleted 3000. Elapsed 0/0 sec


NOTICE:


hundred:


NOTICE:


unique2:


NOTICE:


unique1:


NOTICE:


NOTICE:


Index onek_-


Pages 12; Tuples 1000: Deleted 3000. Elapsed 0/0 sec.


Index onek_-


Pages 19; Tuples 1000: Deleted 3000. Elapsed 0/0 sec.


Index onek_-


Pages 17; Tuples 1000: Deleted 3000. Elapsed 0/0 sec.


Rel onek: Pages: 98 —> 25; Tuple(s) moved: 1000. Elapsed 0/1 sec. Index onek_-

stringul: Pages 28; Tuples 1000: Deleted 1000. Elapsed 0/0 sec


NOTICE:


hundred:


NOTICE:


unique2:


NOTICE:


unique1:


VACUUM


Index onek_-


Pages 12; Tuples 1000: Deleted 1000. Elapsed 0/0 sec. Index onek_-


Pages 19; Tuples 1000: Deleted 1000. Elapsed 0/0 sec. Index onek_-


Pages 17; Tuples 1000: Deleted 1000. Elapsed 0/0 sec.

Compatibility


SQL92


There is no VACUUM statement in SQL92.

D.86 vaeuumdb


Name


vaeuumdb — Clean and analyze a Postgres database


vaeuumdb [ options ] [ -analyze | -z ] [ -alldb | -a ] [ -verbose | -v ] [ -table ’table [ (column [,…] ) ]’ ] [ [-d] dbname ]

Скачать в pdf «PostgreSQL»