Performs a VACUUM (garbage-collect and optionally analyze) on a table.
Usage
dbVacuum(
conn,
name,
full = FALSE,
verbose = FALSE,
analyze = TRUE,
display = TRUE,
exec = TRUE
)
Arguments
- conn
A connection object.
- name
A character string specifying a PostgreSQL table name.
- full
Logical. Whether to perform a "full" vacuum, which can reclaim more space, but takes much longer and exclusively locks the table.
- verbose
Logical. Whether to print a detailed vacuum activity report for each table.
- analyze
Logical. Whether to update statistics used by the planner to determine the most efficient way to execute a query (default to
TRUE
).- display
Logical. Whether to display the query (defaults to
TRUE
).- exec
Logical. Whether to execute the query (defaults to
TRUE
).
See also
The PostgreSQL documentation: http://www.postgresql.org/docs/current/static/sql-vacuum.html
Author
Mathieu Basille mathieu@basille.org