pgtrajVacuum: VACUUM a pgtraj schema.

Description Usage Arguments Value Author(s) Examples

Description

Performs a VACUUM (garbage-collect and optionally analyze) on all the tables of a traj schema.

Usage

1
2
pgtrajVacuum(conn, schema = "traj", full = FALSE, verbose = FALSE,
  analyze = TRUE)

Arguments

conn

Connection object created with RPostgreSQL

schema

String. Name of the schema that stores or will store the pgtraj data model.

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).

Value

TRUE on success.

Author(s)

Balázs Dukai balazs.dukai@gmail.com

Examples

1
2
3
4
5
## Not run: 
  # Vacuum analyze all tables in pgtraj schema with default name "traj"
  pgtrajVacuum(conn)

## End(Not run)

rpostgisLT documentation built on May 2, 2019, 3:04 a.m.